Is there a way to make an autoenter field (replaces existing field contents) NOT update?
I have a field that is basically defined as:
If ( Field1 = "Value" ; Field2 * 2 ; Field3 )
It updates every time Field2 is updated, whether Field1 = Value or not. I tried moving the Field2 * 2 calculation off into a separate field (Field4) and changing the calculation to be:
If ( not IsEmpty ( Field4 ) ; Field4 ; Field3)
But my field is STILL updating whenever Field2 is updated. I feel like there HAS to be a solution to this, but at the moment, I'm stumped.
Any help is appreciated. Thanks in advance.