Copy All Records/Requests script step

Contents > Script steps reference (alphabetical list) > Records script steps > Copy All Records/Requests script step

Copy All Records/Requests script step

Format


Copy All Records/Requests

Options

None.

Web compatibility

This script step is web-compatible.

Description

In Browse mode, copies the values of all records to the Clipboard. In Find mode, copies all find requests. 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 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.

Example

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[]

Script step categories

Contents > Script steps reference (alphabetical list) > Records script steps > Copy All Records/Requests script step