Complex Formula to Script?

442 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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