Script Steps Reference

FILEMAKER SCRIPT STEPS REFERENCE 52
Description
This script step pastes text that is specified in the script, instead of text provided by the user.
Notes
• This script step is intended to paste text into text field types. To insert other types of data
into other types of fields, use either the
Insert Calculated Result script step or the Set
Field script step.
• If the specified field does not exist on the layout where the script is being performed,
Insert Text returns an error code which can be captured with the Get(LastError)
function.
• In a web-published database, use a Commit Record/Request script step after an Insert
Text script step to update the record in the browser window.
Examples
Insert Text [Select; Table1::LastName; "Smith"]
Related topics
Script steps reference (alphabetical list)
Contents
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>; <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.
• Select Go to target field or click Specify to specify 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.
• Calculated result: Click Specify to define the calculation whose results will be inserted by
this script step. In the Specify Calculation dialog box, type the calculation you want
evaluated, or use the field list (on the left) and the functions list (on the right) with the
mathematical and text operators to build the calculation.
Note 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.
Compatibility
This script step is also supported in web publishing and in a FileMaker Server scheduled script.