Email Address Validation

[Tissot]

Hi!

This is how I’m doing it until now:

If(IsEmpty(kEMail);0; If(Position (kEMail;"@" ;1 ; 1 ) > 0 and Position (kEMail;"." ;1 ; 1 ) > 0;1;0))

This Calculation is perfect until it comes to deleting the Email field. Then the Validation won't let me delete the field. Any solution?

Regards.

Ron

[Genx]

I suggest you dont actually use validation but instead give the user some sort of visual indication that the email is invalid, i.e. changing the contents to red... Much more friendly - If you want a real email validation thing (go to www.briandunning.com click Custom Functions on the left and search email).

Finally, don't use IsEmpty()...

Also the below format is a bit more ... slipstreamed and clean.

Oh and if you actually need to know whether an email exists so that you can send an email (i.e. its for a script) -- just add a calc field to check it.

Case(

IsEmpty(kEMail); 0 ;

Position (kEMail;"@" ;1 ; 1 ) > 0 and Position (kEMail;"." ;1 ; 1 ) > 0 ; 1;

0)//Default Value and End Case Statement