I think that'll work.
On Thu, Aug 29, 2013 at 8:22 AM, Young, Ronald P. <rpyo...@southernco.com>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: > arslist@ARSLIST.ORG] *On Behalf Of *Longwing, Lj > *Sent:* Thursday, August 29, 2013 9:01 AM > > *To:* arslist@ARSLIST.ORG > *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 <mbritt...@navisite.com> > 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: > arslist@ARSLIST.ORG] *On Behalf Of *Young, Ronald P. > *Sent:* Thursday, August 29, 2013 9:50 AM**** > > > *To:* arslist@ARSLIST.ORG > *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:arslist@ARSLIST.ORG <arslist@ARSLIST.ORG>] *On Behalf Of *Brittain, > Mark > *Sent:* Thursday, August 29, 2013 8:26 AM > *To:* arslist@ARSLIST.ORG > *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:arslist@ARSLIST.ORG <arslist@ARSLIST.ORG>] *On Behalf Of *Longwing, > Lj > *Sent:* Thursday, August 29, 2013 9:18 AM > *To:* arslist@ARSLIST.ORG > *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 <rpyo...@southernco.com> 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_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
