Email & Website Address Validation

AppSheet AppSheet Q&A
1

How to validate e-mail address so that only letters (a-z), numbers (0-9), periods (.) and @ are allowed. Nothing else is allowed and the total lenght of the e-mail address should not exceed 50 characters.

Same for Website address but without the @ ofcourse!!

Thank You!!

2

For email, in Email column’s valid_if, please try

AND(ANY(EXTRACTEMAILS([_THIS]))=[_THIS], LEN([_THIS])<51)

The column is assumed to be Email type.

3 Likes
3

That is Fab!! one more thing I want to do is that I also want to make sure the e-mail address is entered in lower case.

Also please let me know how to validate the website url.

Thanks!!

4

Total_Solutions:

I want to do is that I also want to make sure the e-mail address is entered in lower case.

Please try

AND(ANY(EXTRACTEMAILS([_THIS]))=[_THIS], LEN([_THIS])<51, FIND(LOWER([_THIS]),[_THIS])=1)

Total_Solutions:

Also please let me know how to validate the website url.

Please try this based on the above expression or an expression based on similar expression.

1 Like