Re: help, help, help

[Heider, Stephen]

**   Sara,   If you don't need to use the auto-generated field in the middle of the Submit transaction:   - Add an Integer field to the form.   - Add a Filter that fires on On Submit - Set Fields to the Integer field with the value of RIGHT($1$,10).     Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Tuesday, August 22, 2006 10:59 AM To: arslist@ARSLIST.ORG Subject: Re: help, help, help ** Sara,   To enforce unique values in a field I would suggest a unique index. As to a ‘Request ID’ type field you may need some sort of a stored procedure for that.   HTH,   Roger A. Nall OSSNMS Sr. Remedy Administrator/Developer T-Mobile USA Desk: 973-644-3963 Cell: 973-652-6723 FAX: 973-267-6628 sf49fanv     AIM IM RogerNall   Yahoo IM   From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of sara abate Sent: Tuesday, August 22, 2006 10:46 AM To: arslist@ARSLIST.ORG Subject: help, help, help   ** I am a new remedy developer and I need help on two of the following things,      1.  I want a field to have unique value.  How can I restrict the field from having duplicate values?  In other words, Is there any way I can block if the current value entered is already in the database?       2.  I want to create an auto generated field.  Anytime a ticket is submitted, the field should be populated automaticlly in increments.  In other word, I want a 'Request ID' kind of field on the form.      Anybody can help me with this please email me at [EMAIL PROTECTED].  I will appreciate it.   Thanks!      Sara   Do you Yahoo!? Next-gen email? Have it all with the all-new Yahoo! Mail. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___