You need to use a LIKE. So it would be:
NOT ('ED TAG ID #' LIKE "[0-9] [0-9] [0-9] [0-9] [0-9] [0-9]")
Mark
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Longwing, Lj
Sent: Thursday, August 29, 2013 14:29
To: [email protected]
Subject: Re: require numerical values
**
I think that'll work.
On Thu, Aug 29, 2013 at 8:22 AM, Young, Ronald P. <[email protected]>
wrote:
**
So I guess doing this should work right?
Run if qualification:
'ED TAG ID #' != "[0-9][0-9][0-9][0-9][0-9][0-9]"
If Action:
Must be a "numerical" value of 6 digits.
Thanks,
Ron Young
"Courage is not the absence of fear, but rather the judgement that
something else is more important than fear." (James Hollingworth)
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Longwing, Lj
Sent: Thursday, August 29, 2013 9:01 AM
To: [email protected]
Subject: Re: require numerical values
**
Yes, but it does nothing to verify that the 6 char's are numeric in
nature :)
On Thu, Aug 29, 2013 at 7:59 AM, Brittain, Mark
<[email protected]> wrote:
**
Ron,
What LENGTHC does is count the number of characters in the referenced
field and then that number in another field like this
First filter (or AL)
Set Field Count LENGTHC(ButtonField)
Second Filter (or AL)
Run If Count !=6
Error Message
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Young, Ronald P.
Sent: Thursday, August 29, 2013 9:50 AM
To: [email protected]
Subject: Re: require numerical values
**
I am not sure if I confused you guys or if I got confused by reading
the replies...J. I got it set to 6 characters by changing that in the database
properties for that field. I want it to be numbers instead of letters only.
Mark, from what yours looks like...it looks like that just sets the
character length to 6...it could be letters or numbers
LJ, looks like this would work but not sure what you're referring to as
"AL"...I do know how to go into filters...
I have attached a screen capture ...hope it helps you understand more.
Thanks,
Ron Young
"Courage is not the absence of fear, but rather the judgement that
something else is more important than fear." (James Hollingworth)
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Brittain, Mark
Sent: Thursday, August 29, 2013 8:26 AM
To: [email protected]
Subject: Re: require numerical values
**
Ron
You could also try a set field LENGTHC(ButtonFIeld) and then an error
message If the number is not equal to 6.
Mark
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Longwing, Lj
Sent: Thursday, August 29, 2013 9:18 AM
To: [email protected]
Subject: Re: require numerical values
**
Ron,
If you want a character field to be exactly 6 numerical values, and to
throw an error if it's not, then you can use this run-if in an AL/Filter
NOT 'Field' = "[0-9][0-9][0-9][0-9][0-9][0-9]"
and have that workflow throw an error.....
On Thu, Aug 29, 2013 at 7:14 AM, Ron Young <[email protected]>
wrote:
OK...I have a form that has a field that is required if a button is
selected. The thing is it requires 6 characters to be entered. How can I set
that to only allow numerical characters (a ticket number) vs N/A. The N/A has
been used recently and that will only throw off my reports so again how do I
change that to be just numerical characters where employees can not enter N/A.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
<https://urldefense.proofpoint.com/v1/url?u=http://www.arslist.org&k=k4uTPtKceKyJbrKTKO%2FDpA%3D%3D%0A&r=acCMp2P5cctjq7hCkmdL%2Bd8SmbryZFsEdaDSOrjVCWM%3D%0A&m=BBR1%2FyS9b7REQPFnvlRM08B9tR0cXqWVeGflSAV8FHc%3D%0A&s=172dfabc2cba24efcb8aceb1a10d17a651b1e404dcec0b020fda95caa1fce33a>
"Where the Answers Are, and have been for 20 years"
_ARSlist: "Where the Answers Are" and have been for 20 years_
________________________________
This e-mail is the property of NaviSite, Inc. It is intended only for
the person or entity to which it is addressed and may contain information that
is privileged, confidential, or otherwise protected from disclosure.
Distribution or copying of this e-mail, or the information contained herein, to
anyone other than the intended recipient is prohibited.
________________________________
This E-mail and any of its attachments may contain Time Warner Cable
proprietary information, which is privileged, confidential, or subject to
copyright belonging to Time Warner Cable. This E-mail is intended solely for
the use of the individual or entity to which it is addressed. If you are not
the intended recipient of this E-mail, you are hereby notified that any
dissemination, distribution, copying, or action taken in relation to the
contents of and attachments to this E-mail is strictly prohibited and may be
unlawful. If you have received this E-mail in error, please notify the sender
immediately and permanently delete the original and any copy of this E-mail and
any printout.
_ARSlist: "Where the Answers Are" and have been for 20 years_
_ARSlist: "Where the Answers Are" and have been for 20 years_
_ARSlist: "Where the Answers Are" and have been for 20 years_
_ARSlist: "Where the Answers Are" and have been for 20 years_
_ARSlist: "Where the Answers Are" and have been for 20 years_
_ARSlist: "Where the Answers Are" and have been for 20 years_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
