Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula match element in list of postal codes (OR)

Topic Labels: Formulas
Solved
Jump to Solution
2504 5
cancel
Showing results for 
Search instead for 
Did you mean: 
TFP
6 - Interface Innovator
6 - Interface Innovator

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
augmented
10 - Mercury
10 - Mercury

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

See Solution in Thread

5 Replies 5
augmented
10 - Mercury
10 - Mercury

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

Grunty
7 - App Architect
7 - App Architect

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

TFP
6 - Interface Innovator
6 - Interface Innovator

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

TFP
6 - Interface Innovator
6 - Interface Innovator

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.

TFP
6 - Interface Innovator
6 - Interface Innovator

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)$')