Unsort Records

Restores the records in the current found set to the order in which the records were entered.




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


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.


Example 1 

Goes to the Print Invoices layout, sorts the records, prints, returns to the original layout, then unsorts the records.

Go to Layout ["Print Invoices"]
Sort Records [Restore; With dialog: Off]
Print [With dialog: Off]
Go to Layout [original layout]
Unsort Records