up vote 1 down vote favorite
share [g+] share [fb]

I have the following code:

=ISNUMBER(FIND("@";[emailAddressField]))

It's not working, can someone recommend a better formula.

Thank you!

The exact problem is... depending on the default site language the ; character needs to at times be , while at other times ;

I'm looking for a language agnostic formula that works with all site languages.

link|improve this question
77% accept rate
feedback

2 Answers

up vote 1 down vote

You can check that it should be "," instead of ";" in =ISNUMBER(FIND("@",[emailAddressField])) at Examples of common formulas and I think that something like calculated fields in SHarePoint are language agnostic for all.

Hope it'll help.

[Update] If you need validation you can here is an article how to use jquery input plugin. In that case user will have to put valid email address.

link|improve this answer
unfortunately they're not language agnostic. ; works in Czech site, while , works in an English site. Crazy I know.... – user879 Mar 22 '11 at 12:38
So you want to prevent user from entering wrong e-mail? Why not to use input mask in that case? – Andriy Shvay Mar 22 '11 at 12:50
I want to use validation on the column. So far we have a theory it is because SP uses Excel validation, and this is language dependent, the functions actually change depending on the language of the site. But its a theory at this stage. – user879 Mar 23 '11 at 12:46
feedback
up vote 1 down vote

I experienced the same problem, it IS language dependend, even the formula names change :-S. We circumvented this using jQuery: bind to the checkbox's onblur, if invalid, show message and disable ok button

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.