Script Steps Reference

Description
The Replace Field Contents script step uses the value in a specified field in the current
record or uses a calculation to replace the value in that field in every record in the current
found set. This step can also be used to reserialize a field in every record in the current
found set.
Example
Sort Records [Restore]
Go to Record/Request/Page [First]
Replace Field Contents [No dialog; script examples::Serial Number;
Serial numbers]
Relookup Field Contents
Format
Relookup Field Contents [No dialog; <table::field>]
Options
• Perform without dialog prevents a dialog box from displaying when the script step
executes that lets the user confirm field information.
• Select Go to target field or click Specify to specify the field that is the target of the
relookup operation. FileMaker Pro moves the cursor to the field you specify. This
must be the match field for the relationship upon which the lookup is based, not the
Lookup source or target field. If no field is selected, Relookup Field Contents returns
an error code that can be captured with the Get(LastError) function.
Web compatibility
This script step is web-compatible.
Description
Copies new values from the lookup source field
into the records that make up the current
found set.
Notes
• The target field specified for the Relookup Field Contents step must be an editable
field.
• Relookups are only performed on the found set of records in the active table.
• Calculation fields cannot be used for the Relookup Field Contents command. If you
use the Relookup Field Contents command, and you're using a calculation field as
the matching value, you must specify one of the input fields for the calculation as the
field parameter for the Relookup Field Contents.