Copy and record data to a field from a variable field
I'd be grateful for some help with what is probably a simple problem, but one that is giving me grief.
I'm trying to create a script to trigger when exiting a field such that another field records the data and won't change, even if the data in the first field is deleted.
I've tried this script which triggers OnObjectExit, but it won't put any data in the second field:
If [Unit::CMA Resit Compensation = “ * “]
Copy [Select; Unit::CMA Resit Compensation]
Paste [Select; Unit::CMA Resit Compensation Copy]
So when data is added to CMA Resit Compensation it will copy to CMA Resit Compensation Copy, but if the first field is set to zero in the future, the second field will still record the original data.
Any thoughts on how I get this to work, or perhaps a smarter way gratefully received.
Thanks in advance.