regex expressions for email

uni
Bronze 2
Bronze 2

The data column type email allows you to enter incorrect email addresses in the form, including those that start with . or include illegal symbols. An error will occur the first time you send it, but to save time, it would be useful if you could use a regular expression with the regex function in valid if. Are there any plans to introduce regex functions in the future?

Solved Solved
1 3 175
1 ACCEPTED SOLUTION


@uni wrote:

Are there any plans to introduce regex functions in the future?


No.  You can implement validation rules for the entered data.  It may not be as simple as s regex expression but you can achieve the same results.  Each column has a Valid_If property where you can implement an expression that checks the entered value.  You can also provide custom error messages when the valid is not valid.  See the article below.

Check form input validity

 

View solution in original post

3 REPLIES 3


@uni wrote:

Are there any plans to introduce regex functions in the future?


No.  You can implement validation rules for the entered data.  It may not be as simple as s regex expression but you can achieve the same results.  Each column has a Valid_If property where you can implement an expression that checks the entered value.  You can also provide custom error messages when the valid is not valid.  See the article below.

Check form input validity

 

Hi! Try this

uni
Bronze 2
Bronze 2

Thank you so much.

I think that valid if judges the input value in the appsheet, but if you add and edit the email directly on the spreadsheet, it doesn't work. You will need a regex function formula in the spreadsheet.

Top Labels in this Space