Undoing a Script

[etsmarines]

Is there a way to undo a script that I just performed. In other words. Give the user an option to completely undo what the script performed? Like an on script/ off script button. So if the script performed a bunch of calculations on some fields and the user later wanted to go and not have that script been run on those fields click a button to undo it?

Erik

[bcooney]

Everything is possible. Your question indicates that perhaps you are overwriting field values, and perhaps you would be best served with a design that didn't do that. "A bunch of calculations on some fields" ...can you expand on that?

For example, if a script adds a record that changes a subtotal, simple deleting or marking that record "void" will "revert" the script that added the record and the subtotal will recalc.

[Lee Smith]

Hi Erik, and welcome to the Forum.

There isn't an UNDO in FileMaker, like you might find other programs such as Adobe PhotoShop. Those UNDOs are usually limited to last save, or session specific anyway. Your descriptions sounds like some time has passed and you have discovered a major error in records that were changed?

Whenever you are looking at Reverting records, it requires a new entry, either through a script, or through manual impute or interaction with functions such as Substitute, Replace, etc. Reverting like this can be very dangerous, and should only be done with a Backup of your File. It is so easy to mess this process up because you are always working with a found set, whether it is ALL Records, or one you have pull by doing a Find.

Without knowing more about what it is you are trying to accomplish, maybe more information on what went wrong, and what you need to change in those records.

In other words, Is it one Record, one Field. one Record, Several Fields, Several Records, one Field, Several Records, Several Fields?

Is this something that you can see happening again in the future?

If so, perhaps an Audit Log like, Ultra Log, or a Field Modification Log such as you can find by doing a search on Database Pros site Link for Field Modification can help you in the future.

HTH

Lee