Script Steps Reference

Description
Pastes information from a field in the last active record into the specified field in the current
record or find request. 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
on page 32. Use this script step to ensure consistency and automate data entry.
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
Go to Record/Request/Page [First]
Enter Find Mode []
Go to Field [Company Name]
Insert From Last Visited []
Insert Current Date
Format
Insert Current Date [Select; <table::field>]
Options
• Select entire contents replaces the contents of a field with the current date. If you
do not select this option, Insert Current Date adds the value of the current date to the
end of the field's existing data.
• Select Go to target field or click Specify to specify the field to paste the date into.
Web compatibility
This script step is web-compatible.
Description
Pastes the current system date into the specified field.
To perform a calculation with the current date, make sure the receiving field is defined as
a date field.
Notes
• If the specified field does not exist on the layout where the script is being performed,
Insert Current Date 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 Current Date script step to update the record in the browser window.