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?
I’d like to optimize my automation by running the same automation whether any field is updated, but perform a change related to the updated field only.
How can I know what field was updated from a script?
Introduction
There are many causes that might lead to loss of data, or, more generally, to the need to restore data from a previous “point in time”.
I’ve also defined what are the “key findings” I learned from that analysis and find most relevant.
I’...
Introduction
I’ve analysed and made the below “State of the Art” regarding the “Backup & Restoration” topic.
This analysis has been done on December 8, 2020.
I’ve also defined what are the “key points” that matters to me, for a reliable Backup & Rest...
I configured an Airtable automation script to trigger when a record matches some conditions.
I had expected to somehow get an “input” containing the said records, but it feels like there isn’t such thing. My goal is to perform processing for the said...
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)$')
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.
