Script Steps Reference

FILEMAKER SCRIPT STEPS REFERENCE 23
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.
Show All Records
Sort Records[Restore; No dialog]
Set Field [Table1::Count; 1]
Loop
Set Field [Table1::Bonus; Table1::Salary * .25]
Go to Record/Request/Page[Next]
Exit Loop If [Table1::Count = 10]
Set Field [Table1::Count; Table1::Count + 1]
End Loop
Related topics
Script steps reference (alphabetical list)
Contents
End Loop
Purpose
Marks the end of a Loop script structure.
Format
End Loop
Options
None.
Compatibility
This script step is also supported in web publishing and in a FileMaker Server scheduled script.
Originated in
FileMaker Pro 6.0 or earlier
Description
Whenever you use a Loop script step, the Manage Scripts feature automatically enters an End Loop
step. The steps between Loop and End Loop are automatically indented and the End Loop step is
placed at the same indentation level as its corresponding Loop step.