From Dwayne Wright PMP
Certified FileMaker Developer
Please Note: If you are viewing this page in a news feeder, the images may get munged up a bit or other formatting of the posting may fail. For the best experience, please visit the journal directly by clicking (here).
Many of the FileMaker faithful do not know that you can copy an entire set of records to the computers clipboard. The Copy All Records script step will copy all the data for all the fields on the current layout. It will be stored in tab delimited format, which is to say the data for each field is separated by a TAB and each record by a carriage return. The resulting information can then be pasted into other programs such as word processing, spreadsheets and even emails!
PLEASE NOTE: The script step will copy all the fields on the current layout when the script step is executed. If you only want a particular collection of field data, it might be a good idea to have a dedicated layout for the fields you want to copy. You can have your script go to the dedicated layout, execute the copy all records command and then go back to the original layout.
More info about the author and FileMaker in general, contact me at email@example.com.
© 2008 - Dwayne Wright - dwaynewright.com
The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.