Sort Records by Field
Purpose
Sorts the records in the current found set according to the context of a specified field.
See also
Format
Sort Records by Field[Ascending/Descending/Associated value list; <table::field>]
Options
•Specify target field specifies the field you want to sort by.
•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 | Yes |
FileMaker Go | Yes |
Custom Web Publishing | Yes |
FileMaker WebDirect | 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.
Example 1
Sorts the current found set by the active field. Can be started by the OnObjectValidate script trigger to maintain the current found set's sort order when field values change.
Sort Records by Field [Ascending]
Example 2
Shows invoices for the current customer ID, with the most recent invoice listed first.
Find Matching Records [Replace; Invoices::Customer ID]
Sort Records by Field [Descending; Invoices::Invoice ID]
Related topics