Script Steps Reference
Table Of Contents
- Chapter 1 Introduction
- Chapter 2 Control script steps
- Chapter 3 Navigation script steps
- Chapter 4 Editing script steps
- Chapter 5 Fields script steps
- Set Field
- Set Next Serial Value
- Insert Text
- Insert Calculated Result
- Insert From Index
- Insert From Last Visited
- Insert Current Date
- Insert Current Time
- Insert Current User Name
- Insert Picture
- Insert QuickTime
- Insert Object (Windows)
- Insert File
- Update Link (Windows)
- Replace Field Contents
- Relookup Field Contents
- Export Field Contents
- Chapter 6 Records script steps
- Chapter 7 Found Sets script steps
- Chapter 8 Windows script steps
- Chapter 9 Files script steps
- Chapter 10 Accounts script steps
- Chapter 11 Spelling script steps
- Chapter 12 Open Menu Item script steps
- Chapter 13 Miscellaneous script steps
- Appendix A Glossary
Chapter 7
|
Found Sets script steps 77
Sort Records
Format
Sort Records [Restore; No dialog]
Options
• Perform without dialog prevents display of a dialog box when the script step
executes that lets the user enter a different set of sort instructions.
• Select Specify sort order or click Specify to create a sort order and store it with the
script step. When Specify sort order is not selected, FileMaker Pro uses the most
recently executed sort instructions.
Web compatibility
This script step is web-compatible
Description
Sorts the records in the current found set according to specified criteria. Find the records
you want to sort (using Perform Find script step on page 71 or Show All Records script
step on page 74) before using the Sort script step. If you sort a repeating field, FileMaker
Pro sorts on only the first entry in that field. You don't need to use the Enter Browse Mode
script step on page 37 or Go to Record/Request/Page script step on page 30 after using
Sort.
Each Sort Records script step can store a unique sort order; the sorting instructions are
stored with the step, not the script. You can use this step several times within the same
script and store a different sort order for each occurrence.
Note Items in the sort order that aren’t valid when the script step is performed are ignored.
When you specify a sort order in a database containing multiple tables
, FileMaker Pro
stores the table name for each sort field in the sort order. For example, a sort order using
the Last Name field of the Contacts table is stored in the sort order as Contacts::Last
Name. If the Sort Records script step is performed when a table other than Contacts is the
active table, Contacts::Last Name cannot be evaluated, and is ignored in the sort order.
Example
Go to Layout ["My sort layout"]
Show All Records
Sort Records [Restore; No dialog]
Print [ ]