Email address validation

There is not a built in function for this, but some of us have formulas squirreled away to do our own validation.  try this one

var text email = Trim([My Email Field]); 

// you will need to decide what to do about leading and trailing spaces.  This tends to happen with copy paste by users.  probably best to treat the field as raw input and use Trim([MyField] )  for all subsequent use of the data entry field. 

var text Warning =If($email="", "Missing email address",

List( "<br>",
//If( begins($email," "), "Leading space character" ), // should not be necessary if TRIMed
//If( ends  ($email," "), "Trailing space character" ), // should not be necessary if TRIMed
If( not Contains($email,"@"), "Missing @ symbol" ),
If( not Contains(Part($email, 2, "@" ),"."), "Missing .com or similar at the end" ),
If( Contains($email, " "), "Has a space inside the email address" ),
If(Part($email, 1,"<>[]{},")<>"", "Bad characters in in the email address"),
If(Part($email, 2,"<>[]{},")<>"", "Bad characters in in the email address"),
If(Begins($email,"<"), "Bad characters in email address"),
If(Ends($email,">"), "Bad characters in email address"),
If(Contains($email, "mailto"), "Bad email address"),
If(Contains($email, ":"), "Bad email address" ),
If(Ends($email, "."), "email ends in a period - that can't be right" ),
If(contains($email, ")"), "email contains a bracket ( or ) - that can't be right",

If(contains($email, "("), "email contains a bracket ( or ) - that can't be right" )

));

If($Warning<>"", "<font color=red>" & $Warning)