Is there a way to format an email address field to contain only one "@"
Our email address field needs to be formatted to only contain/allow entry of one "@".
Thanks, any response is highly appreciated!
BTW: this is better:
not PatternCount( Self ; "," ) and PatternCount ( Self ; "@" ) = 1 or IsEmpty ( Self )
( because so the user can't enter an email without the @ char and still the field can be empty )
You can use field validation to show an alert when validation fails, using a calculation such as:
PatternCount ( field name ; "@" ) > 1
I'll give this a try and let you know my results.
If i have more than one validation calculation for one field i get an error message "an operator is expected here."
Should i use "+" ?
I think you want a logical operator such as OR, And,....
Post your complete calcuation here, if you want us to take a look at it.
I tried y our suggested calculation but received now alert when entering more than one "@" in the email field. Only when I left the field blank and tried to move to the next field did it alert me.
Per your suggestion, here is my calculations:
not PatternCount( Self ; "," ) andPatternCount ( Email ; "@" ) > 1
Thanks man it worked out!!
Appreciate the help guys!
I'll give this a shot and post my results!
This works out perfect!
Retrieving data ...