2 Replies Latest reply on Aug 11, 2016 7:09 AM by coherentkris

    Go to record with a drop-down menù



      i have a table with about 15 records. In the format when i want to go to the next or previous record i use the arrow buttons.

      If i want to "jump" from a record 1 to record 8 is possible to use a drop down menu?


        • 1. Re: Go to record with a drop-down menù

          You could populate the list of values in the dropdown list using a calc that would add values as appropriate for the number of records in the found set, set this into a global field, and then use that field as a the source of the drop down list?


          If the number of records is always going to be 15, then you could just manually make a value list with the numbers 1 through 15 and use that?


          Either way, once you've got your list of values, the user can select the required records value (again, in a global field) and then use the Go To Record script step to target the appropriate record.


          Something along the lines of:


          Go To Record [ specify ; GlobalField with Desired Record Number ]

          • 2. Re: Go to record with a drop-down menù

            yes you can leverage the script triggers available for a drop down control to fire a script that will change records or do whatever you want.

            Right click the drop down control in Layout mode and set script triggers.

            Google FileMaker script triggers and you will find a bunch of learning resources