Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula match element in list of postal codes (OR)

Topic Labels: Formulas
Solved
Jump to Solution
567 5
cancel
Showing results for 
Search instead for 
Did you mean: 

How can I write a formula where I could say "return true if value is 95000, or starts with 923, or …)

I’d probably use a regex for this but airtable doesn’t allow that. What’s the next best thing?

1 Solution

Accepted Solutions

There are limits to what you can do, but it should get you started.

See Solution in Thread

5 Replies 5

There are limits to what you can do, but it should get you started.

Would something like this work for you?:
IF(OR(Value=95000, AND(Value>=92300, Value<=92399), etc..), true, false)

I thought regexes weren’t possible with Airtable :open_mouth: Thanks for pointing this out!

Not really, they’re not numbers but rather strings (postal codes can be all kind of weirdness), and the AND/OR is quite hard to read when there are more than 3 possibilities/combinations.

I was able to do what I was looking for using regexes.

Formula "isPostalCodeAroundParis":

REGEX_MATCH(fieldName, '^(78280|91400|920[0-9]{2}|932[0-9]{2}|93460|940[0-9]{2}|9500[0-9]{1}|95800)$')