Email Checker?

[J e f f]

Is there any way to make FMP4 check to make sure a field named 'email' is
actually in email format (some...@server.com)? Also, is there any way to
make it look for commas and double .'s, etc. Thanks.

Jeff

[Lui W]

Jeff,

Just use the calculated Validation for the field.

Lui

----------
In article <7eu4cl$q75$1...@bgtnsc03.worldnet.att.net>, "J e f f"

[Gregory Blasko]

Hi Jeff,

One validation calculation you could use is:

not Position(email, ",", 1, 1) and not Position(email, "..", 1, 1) and
Position(email, ".com", 1, 1) or Position(email, ".net", 1, 1) or
Position(email, ".edu", 1, 1) or Position(email, ".gov", 1, 1) and
Position(email, "@", 1, 1)

This will not allow commas or double periods and will determine that there is
an "@" symbol in the address, and either a ".com", ".net", ".edu", or ".gov".
You can also include other dot-whatevers. You can also exclude other common
typos, but you'd have to know what they were. This should help a little bit.
Include a custom message if validation fails like "Email does not appear to be
in a valid format". You can also make it a scrict validation if you want.
Let me know how you make out. Good luck!

-Greg