Insert Text
 
Purpose 
Pastes a text value into a field in the current record.
See also 
Copying and moving data in records
Creating scripts to automate tasks
Format 
Insert Text [Select; <table::field>; “<text>”]
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.
 •
Go to target field specifies 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.
 •
<text> is the exact value you want to paste.
Compatibility 
 
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 
Originated in 
FileMaker Pro 6.0 or earlier
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.
Example 1 
Inserts "Draft" into the Status field.
Insert Text [Select; Invoices::Status; "Draft"]
Example 2 
Inserts either "Paid" or "Unpaid" depending on the value of the Payment Date field.
If [ IsEmpty ( Invoices::Payment Date )]
Insert Text [Select; Invoices::Status; "Unpaid"]
Else
Insert Text [Select; Invoices::Status; "Paid"]
End If
Example 3 
Inserts "Draft" into the Status field or displays a dialog if Status is not on the current layout.
Insert Text [Select; Invoices::Status; "Draft"]
If [Get ( LastError ) = 102]
Show Custom Dialog ["Status field is missing on current layout"]
End If
Related topics 
Script steps reference (alphabetical list)
Script steps reference (category list)
Was this topic helpful? Send feedback.