Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

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

cancel
Showing results for 
Search instead for 
Did you mean: 
Mics_Sky
6 - Interface Innovator
6 - Interface Innovator

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