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?
1 Like
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.
1 Like
Hi! Try this
1 Like
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.
1 Like