AnsweredAssumed Answered

Manipulate a Direct Entry Field vs. a Calculation

Question asked by argus2 on Apr 28, 2018
Latest reply on May 2, 2018 by DanielShanahan

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?

Outcomes