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
ChrisChris's avatar
ChrisChris
Qrew Assistant Captain
8 years ago

Let's take a field called [Verify], it is of type formula text. Below is its code.

Case(

[value],1,"OK",2,"OK",3,"Bad",4,"Worse"

)


So what we've done in [Verify] is make its text value either "OK", or "Bad" Or "Worse", depending on the value of [value], when [value] is 1 or 2 or 3 or 4.

If 1 is true, then "OK". IF 2 is true, then "OK", if 3 is true, then "Bad", if 4 is true, then "Worse".

Does this make sense?