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

Copy All Records/Requests

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

See also 

Options 

None.

Compatibility 

 

Product 

Supported 

FileMaker Pro Advanced 

Yes 

FileMaker Go 

Yes 

FileMaker WebDirect 

No 

FileMaker Server 

Yes 

FileMaker Cloud for AWS 

Yes 

FileMaker Data API 

No 

Custom Web Publishing 

No 

Runtime solution 

Yes 

Originated in 

FileMaker Pro 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 Advanced 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.

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."]

Related topics 

Script steps reference (alphabetical list)

Script steps reference (category list)