Script Steps Reference

Fields script steps
F
ILEMAKER SCRIPT STEPS REFERENCE 82
Insert Calculated Result
Purpose
Pastes the result of a calculation into the current field in the current record.
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
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.
Example 1
Inserts the current date if the invoice prints successfully.
Set Error Capture [On]
Print [ ]
Insert Calculated Result [Select; Invoices::Print Status; If ( Get (
LastError ) = 0 ; "Printed on " & Get ( CurrentDate ) ; "Not Printed" )]
Where the script step runs Supported
FileMaker Pro Yes
FileMaker Server scheduled script Yes
FileMaker Go Yes
Custom Web Publishing Yes
FileMaker WebDirect Yes
Runtime solution Yes