Duplicate Record/Request

Duplicates the current record or the current find request.

Options 

None.

Compatibility 

Product Supported
FileMaker Pro Yes
FileMaker Go Yes
FileMaker WebDirect Yes
FileMaker Server Yes
FileMaker Cloud products Yes
FileMaker Data API Yes
Custom Web Publishing Yes

Originated in version 

6.0 or earlier

Description 

In Browse mode, this script step makes a duplicate of the current record. In Find mode, it duplicates the current find request.

If the record has a field set up for automatic entry of values, this script step does not duplicate the value in the field of the current record. In that case, FileMaker Pro generates and enters a new value for the duplicated record. If the field is defined as a lookup or if the Do not replace existing value of field (if any) option is selected for the field, FileMaker Pro duplicates the value from the current record.

To use the Duplicate Record/Request script step with portal rows that display related records, first use the Go to Portal Row script step, and then use the Duplicate Record/Request step. Using the Duplicate Record/Request step when a portal row is selected will duplicate the selected row in the related table. This option is only available when the option to allow creation of related records has been enabled for the relationship.

Example 1 

Performs a find, goes to the last record, and duplicates the record.

Copy
Perform Find [Restore]
Go to Record/Request/Page [Last]
Duplicate Record/Request