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

Question

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.

Can anyone tell me the purpose of the true at the beginning of some case statements.

Example Case(true, eval1, true, eval2,true,false)

Is this setting the default value of the field as true? Or is it only evaluating the eval1 statement if the value in the field is true.

chrischris · Answer

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?

jimharrison · Answer

But we are not using a field called , otherwise your response would make sense and is covered in the reference.&nbsp;

chrischris · Answer

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&nbsp;true. Since it is true ( in this explanation ) that [Value] is equal to&nbsp;1, then the formula text field [Verify] will be equal to "OK".

quickbasecoachd · Answer

imho it works but is a confusing syntax to use,

The results is the same as this

IF(
eval1=true, true,
eval2 = true,true)

but that can be simplied to

IF(
eval1, true,
eval2,true)

In this case both eval 1 and eval true are boolean checkbox formula fields.

chrischris · Answer

Yeah, but If() is for more complex logical constructs. Case() is great to evaluate one variable of limited possible values. The logic probably executes faster than IF().

Forum Discussion

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

Related Content

Dynamic Rule - Or statement?

formula help "if statement"

Jinja If statement equals field value

QuickBase Scripts

IF Statement based on a file being attached