Loop

Repeats a set of script steps, to perform batch processes.

Options 

None.

Compatibility 

Product Supported
FileMaker Pro Yes
FileMaker Go Yes
FileMaker WebDirect Yes
FileMaker Server Yes
FileMaker Cloud products Yes
FileMaker Data API Yes
Custom Web Publishing Yes

Originated in version 

6.0 or earlier

Description 

Use Loop, for example, for exporting container field contents from all records in a found set. This script step and the End Loop script step mark the beginning and end of a repeating structure of script steps. The script performs the script steps that are enclosed within the loop structure until it encounters one of the following:

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, the script editing pane automatically enters an End Loop step.

Example 1 

Copies the contents of the Customers::Work Phone to Customer::Day Contact in all records.

Copy
Go to Record/Request/Page [First]
Loop
Set Field [Customers::Day Contact; Customers::Work Phone]
Go to Record/Request/Page [Next; Exit after last: On]
End Loop

Example 2 

Loops through records to export files that are in the Container field.

Copy
Set Variable [$PATH; Value: Get ( DocumentsPath ) & Products::Container]
Go to Record/Request/Page [First]
Loop
Export Field Contents [Products::Container; "$PATH" ; Create folders: Off]
Go to Record/Request/Page [Next; Exit after last: On]
End Loop