Another option would be to set the pattern in the field property attributes to [0-9][0-9][0-9][0-9][0-9][0-9]. If anything other than 6 numbers is entered the user will get an error indicating the pattern does not match and they will not be able to save the record. One downside to this is that the error can be confusing to the end user.
Todd Arner Great Lakes From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Young, Ronald P. Sent: Thursday, August 29, 2013 8: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...:). 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] On Behalf Of Brittain, Mark Sent: Thursday, August 29, 2013 8:26 AM To: arslist@ARSLIST.ORG<mailto: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] On Behalf Of Longwing, Lj Sent: Thursday, August 29, 2013 9:18 AM To: arslist@ARSLIST.ORG<mailto: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<mailto: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_ ---------------------------------------------------------------------- The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please notify the sender immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"