Reference > Script steps reference > Fields script steps > Insert Calculated Result
 
Insert Calculated Result
Purpose 
Pastes the result of a calculation into the current field in the current record or into a variable.
See also 
Format 
Insert Calculated Result [Select; <table::field or variable>; <formula>]
Options 
Select entire contents replaces the contents of a field or variable. If you don’t select this option:
For a field, replaces only the selected portion of the active field, or inserts data at the insertion point. The default insertion point is at the end of the field's data.
For a variable that doesn’t have container data, inserts data at the end of the variable’s current value. For a variable that has container data, replaces the contents of the variable.
Target specifies the field to paste the calculated result into or the variable to set. If the variable doesn’t exist, this script step creates it (see Using variables).
Calculated result is the calculation whose result will be inserted by this script step.
Compatibility 
 
Where the script step runs 
Supported 
FileMaker Pro 
Yes 
FileMaker Server 
Yes 
FileMaker Go 
Yes 
Custom Web Publishing 
Yes 
FileMaker WebDirect 
Yes 
Runtime solution 
Yes 
Originated in 
FileMaker Pro 6.0 or earlier
Description 
You must specify a target variable, specify a target field on the current layout, click in a field, or use the Go to Field script step before performing this script step. If Target is not specified, the data is placed in the active field. Otherwise, this script step returns an error code that can be captured with the Get(LastError) function.
Notes 
If you manually select field data before you run this script step in FileMaker WebDirect, the script step performs as if you did not make a selection. To select field data before you run this script step in FileMaker WebDirect, use the Set Selection script step.
Example 1 
Inserts the current date if the invoice prints successfully.
Set Error Capture [On]
Print [With dialog: On]
Insert Calculated Result [Select; Invoices::Print Status; If ( Get ( LastError ) = 0 ; "Printed on " & Get ( CurrentDate ) ; "Not Printed" )]
Related topics 
Set Field script step
Defining calculation fields
Script steps reference (alphabetical list)
Script steps reference (category list)