Copy All Records/Requests
Purpose
Copies the values of all records or the search criteria in all find requests to the Clipboard.
See also
Format
Copy All Records/Requests
Options
None.
Compatibility
Where the script step runs | Supported |
FileMaker Pro | Yes |
FileMaker Server | 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 (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."]
Related topics