Insert From Last Visited
 
Purpose 
Pastes data from the last active record into the specified field in the current record or find request.
See also 
Copying and moving data in records
Creating scripts to automate tasks
Format 
Insert from Last Visited [Select; <table::field>]
Options 
 •
Select entire contents replaces the contents of a field. If you do not select this option, Insert From Last Visited inserts the result at the insertion point or at the end of the field's existing data.
 •
Go to target field specifies the field to paste into.
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 
Use this script step to ensure consistency and automate data entry. The active record is the last record where FileMaker Pro performed some activity, such as pasting text or moving into a field with the Go to Field script step.
Note  If the specified field does not exist on the layout where the script is being performed, Insert From Last Visited returns an error code which can be captured with the Get(LastError) function.
Example 1 
Creates a new record and inserts the customer name from the last record that was viewed.
New Record/Request
Insert from Last Visited [Invoices::Customer Name]
Example 2 
Inserts the value from the Customer Name field of the last visited record into a find request, pauses for the user to make modifications, then performs the find.
Enter Find Mode [ ]
Insert from Last Visited [Invoices::Customer Name]
Pause/Resume Script [Indefinitely]
Perform Find [ ]
Related topics 
Set Field script step
Script steps reference (alphabetical list)
Script steps reference (category list)
Was this topic helpful? Send feedback.