Copy All Records/Requests
 
Purpose 
Copies the values of all records or the search criteria in all find requests to the Clipboard.
See also 
Copying and moving data in records
Creating scripts to automate tasks
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 
No 
FileMaker WebDirect 
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 (OS X) 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.
Find Matching Records [Replace; Invoices::Customer ID]
Sort Records [Restore; No dialog]
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)
Was this topic helpful? Send feedback.