Unsort Records
Purpose 
Restores the records in the current found set to their creation order (the order in which they were entered in the file).
Format 
Unsort Records
Options 
None.
Compatibility 
 
Where the script step runs 
Supported 
FileMaker Pro 
Yes 
FileMaker Server scheduled script 
Yes 
FileMaker Go 
Yes 
Custom Web Publishing 
Yes 
FileMaker WebDirect 
Yes 
Runtime solution 
Yes 
Originated in 
FileMaker Pro 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.
Note  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.
Go to Layout ["Print Invoices"]
Sort Records [Restore; No dialog]
Print [No dialog]
Go to Layout [original layout]
Unsort Records
Related topics 
Script steps reference (alphabetical list)
Script steps reference (category list)
Was this topic helpful? Send feedback.