Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Add a regex match function for data validation

cancel
Showing results for 
Search instead for 
Did you mean: 
Andron_Ocean
5 - Automation Enthusiast
5 - Automation Enthusiast

I would love it if Airtable had a formula to determine whether a string (or field reference containing a string) matched a given regular expression.

Google Sheets, for example, has the REGEXMATCH() function. It takes a string/cell reference and a regex, and returns TRUE or FALSE based on whether a match is found.

This would be immeasurably useful. A couple ideas:

Some of these are possible now with complicated sequences of FIND, LEFT, MID, RIGHT, and LEN. It’s hard to debug formulas built this way, however. Regex is compact, easy to test, and comparatively easier to read.

3 Comments
Moe
10 - Mercury
10 - Mercury

We made this tool. It allows you to use Regex on Airtable.

regular-expression

Adam_Minich
Airtable Employee
Airtable Employee

Hello,

Adam from the Airtable support team here. We now have REGEX functions available for use in formula fields. You can find some more information about those functions in this support document.

Cheers!

Justin_Barrett
18 - Pluto
18 - Pluto

This announcement would have been welcome as a standalone post as well, and not just a comment on a thread that only some will see.