Script Steps Reference

Fields script steps
F
ILEMAKER SCRIPT STEPS REFERENCE 49
Description
This script step displays the index for the active field. You can use Insert From Index in Browse or
Find modes.
FileMaker Pro displays the View Index dialog box so the user can select an entry. This method
promotes consistent data entry and correct spelling. For this script step, you can specify a field and
select the entire contents of the field.
FileMaker Pro uses what was last selected for the Show individual words option in the View Index
dialog box (it is not remembered in the script).
Notes
• If the specified field does not exist on the layout where the script is being performed,
Insert From Index returns an error code which can be captured with the
Get(LastError)
function.
• If you have turned indexing off for a field and deselected the option to Automatically
turn indexing on if needed, the index will not display and an error code is returned.
For more information on field indexing see
Defining field indexing options.
Examples
The following example displays the index for a field in Find mode, so the user will select a
preexisting value.
Enter Find Mode [ ]
Insert From Index [Table1::User Name Field]
Perform Find [ ]
Insert From Last Visited
Purpose
Pastes information from a field in the last active record into the specified field in the current record or
find request.
Format
Insert From Last Visited [Select; <table::field>]
Options
• Select entire contents replaces the contents of a field. If you do not use Select Entire
Contents, Paste From Last Record inserts the result at the insertion point or at the end of
the field's existing data.
• Select Go to target field or click Specify to specify the field to paste into.