Skip to main content
Question

Checkbox formula if statement stop

  • January 18, 2019
  • 0 replies
  • 53 views
I'm trying to create a formula checkbox field with a if statement that stops once the checkbox is checked. I have data that is constantly changing so the statement might be true one day and not true the next, but I want the formula to stop computing once the statement is true. 
This topic has been closed for replies.

Well, it will. The If function stops once a condition is met. So, say..

IF([Penny Saved]<>[Penny Earned],FALSE,
[Pope]="Catholic",TRUE,
[Water]="Wet",FALSE,
FALSE)

the first condition is not met
the second condition is met, so the checkbox is checked
and it stops there - the third condition is not evaluated

So if you want your formula to stop working once the checkbox is checked, order your conditions such that all the cases in which it's checked are evaluated first, and once a condition to check the checkbox is satisfied, your formula has done its job and will stop.

Does this answer your question?
  • ForrestParker
  • Quickbase Alumni
  • January 18, 2019
Another thing you might consider is to use an automation instead of a formula.  Set the conditions for when you want it checked in the Trigger.  When those are met the first time then have it check your box.
Terms & ConditionsAccessibility statement