Reset on edit until the user enters a value

Initial value + Reset on edit

Is it possible reset on edit this column to initial value until the user enters a value (whatever it's equal or not to the existing value)?

0 1 69
1 REPLY 1


@eli_debu wrote:

Is it possible reset on edit this column to initial value until the user enters a value


Without "Reset on Edit" active, that is basically the default behavior of each column.  Initial Value is applied (only happens on entry of row) and will will remain until a user changes the value.

Do you have other sources ALSO changing the column?  Is that why you need "Reset ion Edit" turned on?

If so, then it becomes tricky because the app doesn't have a good way to detect that a change is made by an actual person or by, say, the Reset on Edit when the row is loaded.  You would have to become creative.

For example, if I absolutely MUST implement this, I would add a second column that is ONLY shown in the Form, stays blank, and can ONLY be changed by the user.  If a user changes it, then apply it to your main column and then you will know it is a user changed value because the second column is populated.

 

Top Labels in this Space