Monday, November 19, 2012

SharePoint 2010 Column Validation for EMail

Formula:
1.Insert the following formula in the column validation section:
=AND(
 ISERROR(FIND(" ", [Email],1)),
 IF(ISERROR(FIND("@", [Email],2)),
  FALSE,
  AND(
   ISERROR(FIND("@",[Email], FIND("@", [Email],2)+1)),
   IF(ISERROR(FIND(".", [Email], FIND("@", [Email],2)+2)),
    FALSE,
    FIND(".", [Email], FIND("@", [Email],2)+2) < LEN([Email])
   )
  )
 )
)
Source: http://thechriskent.com/2012/08/16/validate-email-address-columns-in-sharepoint/

2.Add a calculated column with the formula below:
=(LEN(LEFT([Email],FIND("@",[Email])-1))>0)
+(LEN(RIGHT([Email],LEN([Email])-FIND(".",[Email],FIND("@",[Email]))))>0)
+(LEN(MID([Email],FIND("@",[Email])+1,FIND(".",[Email],FIND("@",[Email]))-FIND("@",[Email])-1))>0)
+(ISERROR(FIND(" ",[Email]))=TRUE)
=4

Type: Number or Integer
Reference:
http://sharepointsolutions.com/sharepoint-help/blog/2011/12/how-to-validate-an-email-address-using-column-validation-in-sharepoint-2010/

No comments:

Post a Comment