Script Steps Reference

24 FileMaker Script Steps Reference
Every Loop step must have a corresponding End Loop step somewhere after the Loop
step and at the same indentation. Whenever you use a Loop script step, ScriptMaker
automatically enters an End Loop step.
Example
Go to Record/Request/Page [First]
Loop
Set Field [Table1::Bonus; 2500.00]
Go to Record/Request/Page [Next]
Exit Loop if [Get (RecordNumber) = 25]
End Loop
Exit Loop If
Format
Exit Loop If [<Boolean calculation>]
Options
Click Specify to define the Boolean calculation. In the Specify Calculation dialog box, type
the calculation you want evaluated, or use the field list (on the left) and the functions list
(on the right) with the mathematical and text operators to build the calculation.
Web compatibility
This script step is web-compatible.
Description
Exits a Loop if the specified calculation is True (not zero). The script execution continues
with the first script step after the Exit Loop step.
If the calculation if False (zero), the loop is not exited and the script continues with the
script step that follows the Loop script step.
Example
This example calculates a bonus for the top 10 sales agents based on their sales. The
script finds all records and sorts by a field called "Sales" (descending) to arrange the
agents by sales performance. The script starts at the first record and sets the loop counter
variable to 1 (in this example the loop counter field use is a number field with global
storage enabled -- this is the Count field in the example below). Then, the script calculates
the bonus as one quarter of the agent's salary. The script then goes to the next record and
exits the loop if the counter reaches 10. The loop counter increments by 1 and the loop
repeats.
Show All Records
Sort Records[Restore; No dialog]
Set Field [Table1::Count; 1]
Loop