Script Steps Reference
Table Of Contents
- Contents
- About script steps
- Script steps reference (alphabetical list)
- 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 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
- Records script steps
- Found Sets script steps
- Windows script steps
- Files script steps
- Accounts script steps
- Spelling script steps
- Open Menu Item script steps
- Miscellaneous script steps
Navigation script steps
F
ILEMAKER SCRIPT STEPS REFERENCE 28
• 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)]
.
Examples
Enter Browse Mode []
Go to Layout [“Contacts”]
New Record/Request
Go to Field [Table1::First Name]
Go to Record/Request/Page
Purpose
In Browse mode, moves to a record in the found set. In Find mode, displays a find request. In
Preview mode, moves to a page in a report.
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.
Compatibility
This script step is also supported in web publishing and in a FileMaker Server scheduled script.