Hi,
can anyone help figure out this?
what Iโm trying to do is, when I click YES I enter a number for permit fees,
but when I click NO if I already entered the number, I want the number to reset to โzeroโ when I click NO.
@Jafleu
In the Reset on edit? property of [Permit Fees] column, use this expression:
OR(
ISBLANK([Is permit required]),
[Is permit required]=false
)
Thank you LeventK.
It works, but only if the info is saved and sync first, then I return to that page and click NO it reset it, otherwise it wonโt reset the number if I donโt save and sync it first.
I need to reset the number before I save it, if I need to to.
Yes thatโs correct. It wonโt reset when the record is still open. If your selection is โYโ when you save the form and next time you open it, itโs still 150. But if you now press โNโ, it will reset it if your Reset formula is like [Is permit required]=FALSE.
can an if statement works? Like, if [is permit required] = false, then set [permit fees] = 0.
also, I know this isnโt how you formulate the if statement.
You canโt write a value with an IF statement. When you canโt reset the value like this, you could create an event action that would reset the value right after you have saved the form and the criteria is correct.
thank you all for your responses.
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |