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
F
F
ILEMAKER PRO SCRIPT STEPS REFERENCE 289
Focus
Indicates that a record, portal row
, tab, option, field, repeating field repetition, layout part, or
layout object that has been activated by a click, the Tab key, a navigation button, or a script can
then be acted upon in some way. For example, you can change the value in a field that has the
focus; you can work with the data that’s in a record that has the focus; a calculation function can
return the number of the portal row that has the focus.
Footer part
Use the footer part for page numb
ers or dates. This part appears at the bottom of every screen
or page (unless you add a title footer). You can have only one footer in a layout. A field in the
footer displays data from the last record on that page.
Form View
Displays one record at a time. By de
fault, fields appear on separate lines. To select this view,
click Form View in the layout bar.
Formatting bar
In Layout and Browse modes, the area that displays options for format
ting text and objects. To
show or hide the formatting bar, click Formatting
in the layout bar.
Formatting bar in Layout mode
Formula
A set of instructions that FileMaker Pro follows to calculate a value
used in a field or as the
criteria for matching database records.
Found set
The set of records in a table that are made active when you sear
ch for data. When you find all
records, the found set is the entire table.
Full Access privilege set
One of the three predefined privilege sets that appear in every
file. The Full Access privilege set
allows complete read/write access to a file, including making changes to privileges for the file.
Fully qualified name
The complete name of a field or la
yout, expressed using the format tableName::[field or
layout name], where “tableName” is the
name of the underlying table occurrence in the
relationships graph upon which the field or layout is based. A fully qualified name identifies an
exact instance of a field or layout. Because fields and layouts with common names can be
based on different tables, FileMaker Pro uses fully qualified names
to avoid errors in
calculations and scripts.
Function
A predefined, named formula that p
erforms a specific calculation and returns a single, specific
value.
Function list separator
The punctuation character ; (a se
micolon) that separates parameters in a function definition. If
you type a comma (,), FileMaker Pro automatically changes it to a semicolon after you close the
S
pecify Calculation dialog box.