Script Steps Reference

FILEMAKER SCRIPT STEPS REFERENCE 24
Related topics
Script steps reference (alphabetical list)
Contents
Exit Loop If
Purpose
Exits a loop if the specified calculation is True (not zero).
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.
Compatibility
Originated in
FileMaker Pro 6.0 or earlier
Description
If the calculation is True (not zero), the script continues with the script step that follows the End Loop
script step.
If the calculation if False (zero), the loop is not exited and the script continues with the script step
that follows the Exit Loop If script step.
Examples
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.
Where the script step runs Supported
FileMaker Pro Yes
FileMaker Server scheduled script Yes
FileMaker Go Yes
Custom Web Publishing Yes
Instant Web Publishing Yes
Runtime solution Yes