Script Steps Reference
Table Of Contents
- Script steps reference (alphabetical list)
- About script steps
- Control script steps
- Navigation script steps
- Editing script steps
- Fields script steps
- Set Field
- Set Field By Name
- Set Next Serial Value
- Insert Text
- Insert Calculated Result
- Insert From Device
- Insert From Index
- Insert From Last Visited
- Insert From URL
- Insert Current Date
- Insert Current Time
- Insert Current User Name
- Insert Picture
- Insert Audio/Video
- Insert PDF
- Insert File
- Replace Field Contents
- Relookup Field Contents
- Export Field Contents
- Records script steps
- New Record/Request
- Duplicate Record/Request
- Delete Record/Request
- Delete Portal Row
- Delete All Records
- Open Record/Request
- Revert Record/Request
- Commit Records/Requests
- Copy Record/Request
- Copy All Records/Requests
- Import Records
- Export Records
- Save Records As Excel
- Save Records As PDF
- Save Records As Snapshot Link
- Truncate Table
- Found Sets script steps
- Windows script steps
- Files script steps
- Accounts script steps
- Spelling script steps
- Open Menu Item script steps
- Miscellaneous script steps
- Show Custom Dialog
- Allow Formatting Bar
- Refresh Object
- Beep
- Speak (OS X)
- Dial Phone
- Install Plug-In File
- Install Menu Set
- Set Web Viewer
- Open URL
- Send Mail
- AVPlayer Play
- AVPlayer Set Playback State
- AVPlayer Set Options
- Refresh Portal
- Send DDE Execute (Windows)
- Perform AppleScript (OS X)
- Execute SQL
- Send Event
- Comment
- Flush Cache to Disk
- Exit Application
- Get Directory
- Enable Touch Keyboard
- Glossary
Found Sets script steps
F
ILEMAKER PRO SCRIPT STEPS REFERENCE 154
Sort Records
Purpose
Sorts the records in the current found set according to specified criteria.
Format
Sort Records [Restore; With dialog: On/Off]
Options
• With dialog specifies whether to display a dialog box when the script step is performed,
allowing users to enter different sort instructions.
• Specify sort order allows you 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.
• Keep records in sorted order places a new or changed record that’s in sorted order into
the adjusted order after the record is committed. When this option is not selected, new or
changed records stay in the same position in the sort order until a find request is performed
or the records are sorted by different criteria.
Compatibility
Originated in
FileMaker Pro 6.0 or earlier
Description
Find the records you want to sort (using Perform Find script step or Show All Records script step)
before using this 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 or Go to Record/Request/Page
script step after using Sort Records.
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.
Where the script step runs Supported
FileMaker Pro Yes
FileMaker Server Partial
FileMaker Go Yes
Custom Web Publishing Partial
FileMaker WebDirect Yes
Runtime solution Yes