Script Steps Reference

Chapter 5
|
Fields script steps 57
• If the field to be replaced was set up for auto-entry of a serial number and
Prohibit modification of value is not selected, FileMaker Pro will still put
sequential numbers in the selected field, but will do so starting with the next
number to be automatically entered.
• Replace with calculated result displays the Specify Calculation dialog box,
where you can enter a calculation to be used as the replacement value.
Web compatibility
This script step is web-compatible.
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.