What's the formula to assign a numerical value to options from a select field?

Ask the community
1

I’m looking to assign numerical values to a text option from a select field for the Softr database. I tried using the formula that works in Airtable to no avail.
Thanks!

2

What is the formula you use in Airtable?

3

SWITCH(
{Field},
“Choice 1”, 1,
“Choice 2”, 2
)

4

I have used your formula in a test table/fields and it works:

SWITCH({Select}, "Choice 1", 1, "Choice 2", 2)

These are alternatives:

IF({Select} = "Choice 1", 1, IF({Select} = "Choice 2", 2))

IF({Select} = "Choice 1", 1, 2)