Script Steps Reference
Table Of Contents
- Contents
- About script steps
- Script steps reference (alphabetical list)
- Control script steps
- Navigation script steps
- Editing script steps
- Fields script steps
- Set Field
- Set Field By Name
- Set Next Serial Value
- Insert Text
- Insert Calculated Result
- Insert From Index
- Insert From Last Visited
- Insert From URL
- Insert Current Date
- Insert Current Time
- Insert Current User Name
- Insert Picture
- Insert QuickTime
- Insert Audio/Video
- Insert PDF
- Insert File
- Replace Field Contents
- Relookup Field Contents
- Export Field Contents
- Records script steps
- New Record/Request
- Duplicate Record/Request
- Delete Record/Request
- Delete Portal Row
- Delete All Records
- Open Record/Request
- Revert Record/Request
- Commit Records/Requests
- Copy Record/Request
- Copy All Records/Requests
- Import Records
- Export Records
- Save Records As Excel
- Save Records As PDF
- Save Records As Snapshot Link
- Found Sets script steps
- Windows script steps
- Files script steps
- Accounts script steps
- Spelling script steps
- Open Menu Item script steps
- Miscellaneous script steps
FILEMAKER SCRIPT STEPS REFERENCE 111
Compatibility
Originated in
FileMaker Pro 12.0
Description
Sorts the records in the current found set according to the context of a specified field, letting you
create scripts that behave similarly to interactively using the shortcut menu in Table View. If you do
not specify a field, the script sorts by the field that is active when the script runs. If there is no active
field when the script runs, FileMaker
Pro displays an invalid sort order alert.
Tip You can find the records you want to sort (using Perform Find script step or Show All Records
script step) before using this script step. You don't need to use the Enter Browse Mode script step or
Go to Record/Request/Page script step after using Sort Records by Field.
Examples
The following example sorts all records in the database in alphabetical order by the City field, then
prints the output.
Go to Layout ["My sort layout"]
Show All Records
Sort Records by Field[Ascending; Membership Info::City]
Print [ ]
The following example sorts data by month from January to December when data in the Month field
is entered as a custom value list beginning in January and ending in December:
Sort Records by Field [Associated value list; Sales::Month]
Related topics
Script steps reference (alphabetical list) script step
Contents script step
Where the script step runs Supported
FileMaker Pro Yes
FileMaker Server scheduled script Yes
FileMaker Go Yes
Custom Web Publishing Yes
Instant Web Publishing Yes
Runtime solution Yes