Script Steps Reference

Table Of Contents
Found Sets script steps
F
ILEMAKER SCRIPT STEPS REFERENCE 152
Sort Records
Purpose
Sorts the records in the current found set according to specified criteria.
Format
Sort Records [Restore; No dialog]
Options
Perform without dialog prevents display of a dialog box when the script step executes that
lets the user enter a different set of sort instructions.
Specify sort order allows you to create a sort order and store it with the script step. When
Specify sort order is not selected, FileMaker
Pro uses the most recently executed sort
instructions.
Keep records in sorted order places a new or changed record that’s in sorted order into
the adjusted order after the record is committed. When this option is not selected, new or
changed records stay in the same position in the sort order until a find request is performed
or the records are sorted by different criteria.
Compatibility
Originated in
FileMaker Pro 6.0 or earlier
Description
Find the records you want to sort (using Perform Find script step or Show All Records script step)
before using this script step. If you sort a repeating field, FileMaker Pro sorts on only the first entry in
that field. You don't need to use the Enter Browse Mode script step or Go to Record/Request/Page
script step after using Sort Records.
Each Sort Records script step can store a unique sort order; the sorting instructions are stored with
the step, not the script. You can use this step several times within the same script and store a
different sort order for each occurrence.
Where the script step runs Supported
FileMaker Pro Yes
FileMaker Server scheduled script Partial
FileMaker Go Yes
Custom Web Publishing Partial
FileMaker WebDirect Yes
Runtime solution Yes