Copy All Records/Requests

Copies the values of all records or the search criteria in all find requests to the Clipboard.

Options 

None.

Compatibility 

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

Originated in version 

6.0 or earlier

Description 

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

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 (macOS) when there is no active field.)

Notes 

  • Contents that you cut or copy to the Clipboard are accessible to other applications.
  • 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.
  • Any fields located in popovers are ignored when you copy records.

Example 1 

Finds all records with the same Customer ID as the current record, sorts, copies the contents of all the records in the found set, and displays a dialog box.

Copy
Find Matching Records [Replace; Invoices::Customer ID]
Sort Records [Restore; With dialog: Off]
Copy All Records/Requests
Show Custom Dialog ["You can now paste data from the current " & Get ( FoundCount ) & " invoices."]