Script Steps Reference

Fields script steps
F
ILEMAKER SCRIPT STEPS REFERENCE 47
Options
• Select entire contents replaces the contents of a field. If you do not select this option,
Insert Text inserts the specified value at the end of the field's data.
• Select Go to target field or click Specify to specify the field to receive the pasted
information. If no field is selected, the Insert Text command will place the specified text after
the insertion point. If no field is active at the time the command executes, it has no effect.
Also, if the selected field is not present on the current Layout, the Insert Text command has
no effect.
• Specify displays the Specify dialog box where you can enter the exact value you want to
paste.
Compatibility
This script step is also supported in web publishing and in a FileMaker Server scheduled script.
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"]
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>]