Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 6512 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I want to create an A-Z navigation bar that will allow users to "jump to" a record in the found set, based on the first letter of the <> field. The purpose of the nav bar is so that users can avoid scrolling through lots of records, or typing in criteria for finds. I envision it looking like this: A | B | C | D |... |XYZ, with each letter as a button/script. When the user clicks on "C" I want the script to sort the found set in alpha order and then make the active record the first record in the found set that begins with the letter "C".

I should be able to write the script, but I can't figure out the calculation to move to a different record in the found set.

Is anyone using a nav bar like this?

Posted

Ok I just re-read this post. I misread a part of it. What you are trying to do can be done. Read the thread that I pointed out to you.

As it states, create the stored calculation key to get the starting letter for each record.

Then create a global text field and create a self joining relationship from this field to the calc field.

Then your script that your buttons call could pass the script parameter as the other post stated. However, rather than doing a find, you will set the global field, sort step, and then do a Go to Related Record step.

for you XYZ, the set field would be

Set field [gLetter; X ¶ Y ¶ Z ]

This topic is 6512 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.