Sorting Records

After all that fuss about finding records, the sorting script steps are refreshingly simple. There’re only two of them, and you already know how to use both. The Sort Records script step behaves in a now-familiar way. All by itself, it brings up the Sort dialog box when the script runs. If you turn on its “Specify sort order” option, you can preload the sort dialog box with a specific sort order. Finally, turn on the “Perform without dialog” option to sort the records without bothering the user with a dialog box at all.

If the records are already sorted, you can unsort them from a script. For instance, you might sort records for a report, but you want to return them to their unsorted order when the report is finished so your users don’t get confused. Just use the Unsort Records script step. It does its job with no options.

Get FileMaker Pro 9: The Missing Manual now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.