Unsort Records
Restores the records in the current found set to the order in which the records were entered.
Options
None.
Compatibility
| Product | Supported |
| FileMaker Pro | Yes |
| FileMaker Go | Yes |
| FileMaker WebDirect | Yes |
| FileMaker Server | Yes |
| FileMaker Cloud | Yes |
| FileMaker Data API | Yes |
| Custom Web Publishing | Yes |
Originated in version
6.0 or earlier
Description
Use this script step when it's important to maintain the original creation order, as with invoices entered by invoice number or membership records entered by date.
Notes
- You don't need to perform an Unsort Records script step before executing a Sort Records script step.
Example 1
Goes to the Print Invoices layout, sorts the records, prints, returns to the original layout, then unsorts the records.
Copy
Go to Layout ["Print Invoices"]
Sort Records [Restore; With dialog: Off]
Print [With dialog: Off]
Go to Layout [original layout]
Unsort Records