My app has questions along the lines of:
Have fees been paid? Yes/No
Followed by another question:
How much? Price
I would like the second question to default, or change, to zero if the answer to the first question is “No”, or allow the user to input a $n.nn value if the answer is “Yes”. (More info - If the answer to the first question is “No” it would also skip the second question but I don’t have a problem with this bit.)
I’m thinking of a scenario where the user accidentally answers “Yes” and types in an incorrect amount >0.00, then realises they’ve made a mistake and changes the answer to “No” but forgets to update the amount field to zero.
I’ve tried putting an IF formula in the App Formulae field but when it didn’t work, realised this “Computes the value for this column INSTEAD of allowing user input.” Basically, I would like it to compute IF then zero else user input.
Thanks in advance for any help on this.