Logical test CASE(), the brother of IF ()


#1

Please correct me if i’m wrong. I don’t see a CASE statement in Airtable.
It’s a classical one but still very useful if you can avoid unreadable nested IF statements :

CASE (

condition1; Statement if condition1 is TRUE; statement if condition1 is FALSE;
Condition2; Statement if condition2 is TRUE; statement if condition2 is FALSE; …

DEFAULT VALUE when nothing else matched )

Advantage: The evaluation ends with the first condition that matches