Insert Text

Reference > Script steps reference > Fields script steps > Insert Text

Insert Text

Purpose

Pastes a text value into a field in the current record.

See also

Copying and moving data in records

Automating tasks with scripts

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	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.

•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 "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 box 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