Forum Discussion

JimHarrison's avatar
JimHarrison
Qrew Champion
8 years ago

What does the true value mean at the beginning of some case statements in QuickBase?

I looked at the Formula reference and through the community and don't see an explanation to this syntax.  I can see other language references on Google but want to get specific documentation. ...
Formulas and functions
JimHarrison's avatar
JimHarrison
Qrew Champion
8 years ago
But we are not using a field called , otherwise your response would make sense and is covered in the reference. 
  • ChrisChris's avatar
    ChrisChris
    Qrew Assistant Captain
    8 years ago
    So, as we evaluate [Value], we are asking, is [value] equal to 1? If it is equal to 1, then that logically equates to boolean true. Since it is true ( in this explanation ) that [Value] is equal to 1, then the formula text field [Verify] will be equal to "OK".
  • JimHarrison's avatar
    JimHarrison
    Qrew Champion
    8 years ago
    So the first "true" is referring to the current value of the formula. The field where the case statement formula is stored.

    Given it is a checkbox field then where 2,3,4 are other fields being evaluated.
    Case(true, true,[2],true,[3],true,[4],true,false)