Script Steps Reference
Table Of Contents
- 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
- Found Sets script steps
- Windows script steps
- Files script steps
- Accounts script steps
- Spelling script steps
- Open Menu Item script steps
- Miscellaneous script steps
- Get Directory
- 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
- Enable Touch Keyboard
- Glossary
Found Sets script steps
F
ILEMAKER SCRIPT STEPS REFERENCE 147
Show All Records
Purpose
Finds all records in the table underlying the foreground window and selects the current record.
Format
Show All Records
Options
None.
Compatibility
Originated in
FileMaker Pro 6.0 or earlier
Description
Use this script step to redisplay all the records after working with a found set.
Use Show All Records in Browse mode or Preview mode. If you perform this script step in Find
mode or Layout mode, FileMaker
Pro switches to Browse mode after the records have been found.
Example 1
Goes to the Invoices layout, shows all records, and performs a sort.
Go to Layout [“Invoices”]
Show All Records
Sort Records [Restore; No dialog]
Example 2
Performs a find, shows all records if no records were found, and sorts the found set.
Perform Find [Restore]
If [Get (FoundCount) = 0]
Show All Records
End If
Sort Records [Restore; No dialog]
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