Sort Records by Field
Purpose 
Sorts the records in the current found set according to the context of a specified field.
Format 
Sort Records by Field[Ascending/Descending/Associated value list; <table::field>]
Options 
 •
Select Specify target field or Specify, select a field you want to sort by, and click OK.
Tip  You can double-click the script step in the list to specify the target field.
 •
Ascending displays data in ascending order.
 •
Descending displays data in descending order.
 •
Associated value list displays data in the order determined by the value list associated with the field.
Compatibility 
 
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 
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 steps reference (category list)
 
Was this topic helpful? Send feedback.