Email & Website Address Validation

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!! :stuck_out_tongue_winking_eye:

Thank You!! :pray: :blush:

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.

1 Like

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!! :blush:

Please try

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

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

1 Like