You may want to allow for numeric characters in the e-mail address as well. If
so, just modify the 'Run If' qualification in the first active link to the
following:
'Email' LIKE "[EMAIL PROTECTED]"
----- Original Message -----
From: Mahesh
Newsgroups: gmane.comp.crm.arsystem.general
To: [email protected]
Sent: Wednesday, April 23, 2008 1:41 PM
Subject: Re: Error Message on Submit if a field has special characters.
** That worked. Thanks Thomas.
On 4/23/08, Thomas Bean <[EMAIL PROTECTED]> wrote:
In that case, I think I would probably use two separate active links.
Active Link 1:
Run If: 'Email' LIKE "[EMAIL PROTECTED]"
If Action: Error Message (e.g., "E-mail address contains invalid
characters...")
Active Link 2 (higher execution order):
Run If: NOT ('Email' LIKE "[EMAIL PROTECTED]")
If Action: Error Message (e.g., "E-mail address is formatted
incorrectly...")
The first active link would throw an error if any non-alpha characters
(excluding "@" and ".") are entered into the e-mail address field.
The second active link would throw an error if the field value isn't
formatted as [any valid [EMAIL PROTECTED] valid string].[any valid string].
If you use the ARFPerl plugin, you might also be able to use a Perl module
such as Email::Valid to perform the validation for you in a filter.
--Thomas
----- Original Message -----
From: Mahesh
To: Thomas Bean
Sent: Wednesday, April 23, 2008 12:52 PM
Subject: Re: Error Message on Submit if a field has special characters.
Hello Thomas
Actually I am looking for syntax for validating email. If I use ALPHA for
email, it wont accept "@" or ".". So is the reason I was using the following in
the RUN IF of an active link
((NOT ('Email' LIKE "[EMAIL PROTECTED]")) OR (NOT ('Email' LIKE "%.%")))
Please advise if there is better way to do this.
Mahesh
On 4/23/08, Thomas Bean <[EMAIL PROTECTED]> wrote:
**
Hi Mahesh,
The easiest solution, which doesn't require any workflow, would be to
specify the $ALPHA$ keyword as the pattern in the character field properties.
This will only allow alphabetic characters or blank spaces to be entered into
the character field, and will generate a generic error message upon submit if
any other characters are entered into the field.
Otherwise, if you prefer to use an active link or filter to generate a
custom error message, you can use a Run If qualification such as:
'myField' LIKE "%[^a-z]%"
This qualification should match any single character not within the
range [a-z].
HTH,
Thomas
----- Original Message -----
From: Mahesh
Newsgroups: gmane.comp.crm.arsystem.general
To: [email protected]
Sent: Wednesday, April 23, 2008 11:13 AM
Subject: Re: Error Message on Submit if a field has special
characters.
**
Sorry hit the send button quickly. I have just used a similar
qualification for validating email addresses...
((NOT ('Email' LIKE "[EMAIL PROTECTED]")) OR (NOT ('Email' LIKE
"%.%")))
I guess you can use a similar qualification.
On 4/23/08, Mahesh <[EMAIL PROTECTED]> wrote:
Hello Everyone
I have a character field for inputting the name of a person. I am
trying to write an active link that will throw an error message if that field
has special characters (anything apart from A - Z). What kind of a
qualification do I need to put in RUN IF.
Environment: ARS 7, SQL Server 2005, Custom Built HD
Appreciate your time and help in advance.
Thanks
Mike
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers
Are" html___
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers
Are" html___
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
