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