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

Complex Formula to Script?

193 0
Showing results for 
Search instead for 
Did you mean: 

Hey there.

I wrote a basic IF statement that checks content of some records. This was the IF Statement IF(A,A,IF(B,B,C)). Now I need something a little more complex, I need to check if variable A is an email address. I am thinking something along the lines of IF(FIND(’@’,A),“Hyperlink to A”,IF(B,B,C)). So I was wondering if this is getting to complex for the formulas of Airtable and I might just need to run a script that checks for the email if it is then sends the user to a place that creates and email for them to fill.

0 Replies 0