How to test scripts while preserving data
What are the best practices to develop and test scripts using data altering commands such as 'Set field'? Unfortunately, the option to undo easily whatever a script did to the data does not seem available (if it is, please let me know).
So far, I have had the following ideas:
- add a few dummy records on which to perform the tests.
Cons: in the case of potentially complex text fields, a few records might not reflect the diversity of the data
- use 'Show custom dialog' to preview the results of a calculation before giving it the power to actually change data
Cons: text format (bold, italics, etc) is not shown in the dialog box
- copy the entire database
I would be most interested in reading the thoughts of FileMaker developers on the question. W.