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
30 FileMaker Script Steps Reference
Tips
• The Go to Layout script step can only take you to layouts defined in the same file as the
script itself. To go to layouts in an external file, define a script in that file using the Go to
Layout script step, and call that script from the first file using the Perform Script script step
on page 15.
• Layout Name by calculation recognizes layouts with the same names in the order in which
they were created. If you have multiple layouts with the same name, either select the
specific layout you want from the layout list or use Layout Number by calculation.
• Define an unstored calculation field with the function Get(LayoutNumber) function and
place it on your layouts to verify the layout numbers of your layouts.
• When a file has two or more tables, FileMaker Pro appends the name of the source table to
the layout name for clarity. For example, Go to Layout [“Layout #2” (TableB)].
Example
Enter Browse Mode []
Go to Layout [“Contacts”]
New Record/Request
Go to Field [Table1::First Name]
Go to Record/Request/Page
Format
Go to Record/Request/Page [<first/last/previous/next/by
calculation>]
Options
Specify lets you choose from the following options.
• First moves to the first record in the file or found set
, displays the first find request, or
moves to the first page in a report.
• Last moves to the last record in the file or found set, displays the last find request, or
moves to the last page in a report.
• Previous moves to the previous record in the file or found set, displays the previous
find request, or moves to the previous page in a report. Exit after last tells FileMaker
Pro to stop the script when it reaches the last record in the found set. You can use
Exit after last with the Loop script step to exit out of a loop after the last record.
• Next moves to the next record in the file or found set, displays the next find request,
or moves to the next page in a report. Exit after last tells FileMaker Pro to exit the
script or control structure (like a loop) when it reaches the last record in the found set.
• By Calculation lets you create a calculation to determine the index number for the
desired record, find request, or page in Preview mode.
Note Exit after last will exit a loop but does not stop or exit a script.