10 Replies Latest reply on Sep 8, 2016 8:02 AM by hncwilson

    Way to keep Autoenter Field (replaces existing) from updating?

    hncwilson

      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.