Column validation on email address

%3CLINGO-SUB%20id%3D%22lingo-sub-2580184%22%20slang%3D%22en-US%22%3EColumn%20validation%20on%20email%20address%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2580184%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20column%20that%20contains%20email%20addresses.%20I%20would%20like%20SharePoint%20to%20check%20the%20email%20address%20when%20it%20is%20entered%20to%20make%20sure%20the%20emails%20are%20being%20entered%20properly.%3C%2FP%3E%3COL%3E%3CLI%3Ethe%20address%20must%20have%20a%26nbsp%3B%3CSTRONG%3E%40%26nbsp%3B%3C%2FSTRONG%3Efollowed%20by%20%3CSTRONG%3Eschool.edu%3C%2FSTRONG%3E%3C%2FLI%3E%3CLI%3Ethe%20address%20left%20of%20the%26nbsp%3B%40%20must%20be%20formed%26nbsp%3B%3CSTRONG%3Efirst.last%3C%2FSTRONG%3E%3C%2FLI%3E%3C%2FOL%3E%3CP%3EI've%20tried%20inputting%20some%20code%20I%20found%20on%20the%20net%20but%20so%20far%20I've%20found%20that%20every%20address%20is%20rejected.%20Using%20SharePoint%20Online%20in%20Office%20365.%20I%20read%20a%20comment%20from%20a%20user%20that%20this%20doesn't%20work%20in%20SharePoint%20Online.%20Does%20anyone%20have%20any%20information%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDetails%3A%20SharePoint%20Library%2C%20column%20is%20named%26nbsp%3B%3CSTRONG%3EapproverEmail%3C%2FSTRONG%3E.%20Code%20I've%20been%20trying%20to%20work%20with%20follows%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DAND(ISERROR(FIND(%22%20%22%2C%20%5BapproverEmail%5D%2C1))%2CIF(ISERROR(FIND(%22%40%22%2C%20%5BapproverEmail%5D%2C2))%2CFALSE%2CAND(ISERROR(FIND(%22%40%22%2C%5BapproverEmail%5D%2C%20FIND(%22%40%22%2C%20%5BapproverEmail%5D%2C2)%2B1))%2CIF(ISERROR(FIND(%22.%22%2C%20%5BapproverEmail%5D%2C%20FIND(%22%40%22%2C%20%5BapproverEmail%5D%2C2)%2B2))%2CFALSE%2CFIND(%22.%22%2C%20%5BapproverEmail%5D%2C%20FIND(%22%40%22%2C%20%5BapproverEmail%5D%2C2)%2B2)%20%26lt%3B%20LEN(%5BapproverEmail%5D)))))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3BThanks%2C%3C%2FP%3E%3CP%3EAnne%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2580184%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

I have a column that contains email addresses. I would like SharePoint to check the email address when it is entered to make sure the emails are being entered properly.

  1. the address must have a followed by school.edu
  2. the address left of the @ must be formed first.last

I've tried inputting some code I found on the net but so far I've found that every address is rejected. Using SharePoint Online in Office 365. I read a comment from a user that this doesn't work in SharePoint Online. Does anyone have any information?

 

Details: SharePoint Library, column is named approverEmail. Code I've been trying to work with follows:

=AND(ISERROR(FIND(" ", [approverEmail],1)),IF(ISERROR(FIND("@", [approverEmail],2)),FALSE,AND(ISERROR(FIND("@",[approverEmail], FIND("@", [approverEmail],2)+1)),IF(ISERROR(FIND(".", [approverEmail], FIND("@", [approverEmail],2)+2)),FALSE,FIND(".", [approverEmail], FIND("@", [approverEmail],2)+2) < LEN([approverEmail])))))

 Thanks,

Anne

0 Replies