I have a simple Number field (TimeEst) that allows the direct entry of estimated time (in minutes). i.e. 20.
There are occasions when I want this field to temporarily become "0" -without manually changing the value to "0" and losing the original entry. A simple on/off click of a checkbox would be perfect, toggling between "0" and the original entered value.
I added a checkbox field (NoCalc_Checkbox) to create the "toggle", but I can only make this work if I change the simple number field (TimeEst) to a Calculation using this:
If ( NoCalc_Checkbox = "yes" ; 0 ; TimeEst)
...This toggles the value back and forth but I've now lost the ability for direct entry.
Is there a better way to do this?