Script Steps Reference

FILEMAKER SCRIPT STEPS REFERENCE 56
In this example, Table1::FullName contains the literal value “Table1::FullName” and Table2::Name
contains “John Smith”. After the step completes, the value in “Table1::FullName” is “John Smith”.
Set Field By Name[“Table1::FullName”;Table2::Name]
Note The context for the calculation (determined in the upper left corner of the Specify Calculation
dialog box) is essential for proper evaluation.
Example 4
The following example uses the GetFieldName function to ensure that FileMaker Pro retrieves the
fully qualified name of the target field and the Evaluate function to extract the value stored in the
target field, then replaces the contents of fieldName with the data value located in the Name field in
related Table2.
Set Field By Name
[GetFieldName(Evaluate(Location::fieldName));Table2::Name]
Example 5
This example uses a field name contained in a variable to calculate temperatures. A user enters the
temperature in field F or field C and runs the script in order to convert temperatures between
Fahrenheit and Celsius.
If [Get (ActiveFieldName) = “F”]
#Convert Fahrenheit to Celsius
Set Variable [$TargetField; Value:”TableName::C”]
Set Field By Name [$TargetField; (5/9)*(Get (ActiveFieldContents)-32)]
Else if [Get (ActiveFieldName) = “C”
#Convert Celsius to Fahrenheit
Set Variable [$TargetField; Value:”TableName::F”]
Set Field By Name [$TargetField; (9/5)*Get (ActiveFieldContents)+32]
Related topics
Script steps reference (alphabetical list)
Contents
Set Next Serial Value
Purpose
Resets the next serial value in an auto-entry serial number field.
Format
Set Next Serial Value [<table::field>; <value or formula>]
Options
• Select Specify target field or click Specify to specify the serial number field on which the
script step will operate. The field you specify must be defined as an auto-entry serial
number field.
• Calculated result: Click Specify to enter the next serial value or create a calculation to
determine the next serial value.