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 142
Perform Find
Purpose
Finds records using the current or stored find requests.
Format
Perform Find [Restore]
Options
The Specify Find Requests dialog box allows you to create and manage find requests. The requests
you create are stored with the script step. For more information, see Specify Find Requests and Edit
Find Request dialog boxes.
• New opens the Edit Find Request dialog box, where you define criteria for a find request.
• Edit opens a selected find request from the list.
• Duplicate duplicates one or more selected find requests from the list.
• Delete deletes one or more selected find requests from the list.
The Edit Find Request dialog box allows you to create or edit find request criteria.
• For Action, select Find Records or Omit Records to specify whether this find request will
find or omit records. Finding records adds them to your
found set. Omitting records
excludes them. An individual request can find or omit records; use multiple requests if you
need to find and omit records during the same Perform Find script step.
• Find records when (or Omit records when) shows a list of the fields in your current table.
To construct a find request, begin by selecting a field from this list.
• To select a field from a related table, click the name of the current table at the top of the
list and select the related table you want. Select a related field from this new list.
• Change the value in Repetition to specify a particular cell of a repeating field.
• Type your search criteria for the selected field in the Criteria area.
• Click Insert Operator to further refine your search criteria. See Finding records.
• Click Add to add your criteria to the find request.
• To change existing criteria, select the line containing the field and criteria from the top of the
dialog box, and make your changes to field and/or criteria. Click Change to store your
changes.
• To delete existing criteria, select the line containing the field and criteria from the top of the
dialog box and click Remove.