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.
See also 
Format 
Insert Calculated Result [Select; <table::field>; <value or formula>]
Options 
Select entire contents replaces the contents of a field. If you don't select this option, Insert Calculated Result replaces only the selected portion of the current field, or inserts the result at the insertion point. The default insertion point is at the end of the field's data.
Go to target field specifies the field to paste the calculated results into. The target field must be present on the layout to paste successfully. If no field is active when the script is performed, the step has no effect.
<value or formula> is the calculation whose results 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 
If the specified field does not exist on the layout where the script is being performed, Insert Calculated Result returns an error code which can be captured with the Get(LastError) function.
Note  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)