Home > Reference > Script steps reference > Records script steps > Copy All Records/Requests

Copy All Records/Requests

Purpose 

In Browse mode, copies the values of all records to the Clipboard. In Find mode, copies all find requests.

Format 

Copy All Records/Requests

Options 

None.

Compatibility 

 

Where the script step runs	Supported
FileMaker Pro	Yes
FileMaker Server scheduled script	Yes
FileMaker Go	Yes
Custom Web Publishing	Yes
Instant Web Publishing	Yes
Runtime solution	Yes

Originated in 

FileMaker Pro 6.0 or earlier

Description 

Text fields are copied in tab-delimited format, without styles, in the order they appear in the record layout. Text in container fields is also copied. (This script step is equivalent to choosing Copy from the Edit menu while holding down the Shift key (Windows) or Option key (Mac OS) when there is no active field.)

Note  When using the Copy All Records/Requests step with repeating fields, FileMaker Pro inserts the group separator character between each repetition. You can use a text editor to replace these characters with another delimiter such as a tab or space.

Examples 

This script finds and sorts a set of records, switches to the Data Entry layout, copies the contents of the found set to the Clipboard, switches layouts and tables, creates a new record, and pastes the contents of the Clipboard to the History field.

Perform Find [Restore]
Sort Records [Restore; No dialog]
Go to Layout ["Data entry"]
Copy All Records/Requests
Go to Layout ["History table"]
New Record/Request
Paste [Select; History table::History]
Commit Records/Requests[]

Related topics 

Script steps reference (alphabetical list)

Script steps reference (category list)