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?
Page 1 / 1
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)
There are limits to what you can do, but it should get you started.
I thought regexes weren’t possible with Airtable 
Thanks for pointing this out!
Would something like this work for you?:
IF(OR(Value=95000, AND(Value>=92300, Value<=92399), etc..), true, false)
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)$')
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.