Integer field sequence number
Hi: I have a integer field in a form. I want this field to be populated with a number when a record is created and the number increasing by 1 for each new record. Like a sequence generator. Is there something out-of-box field? or do I have to build some workflow for this to happen? TIA Ravi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Integer field sequence number
Ravi, Why not use field 1's value? ( You may have a good reason, but sometimes it helps to know what your trying to do so that the best solution can be approached in the discussion. Instead of just answering the question with a simple. Nothing out of the box that does that, other than field 1.) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Mon, Jun 23, 2008 at 3:42 PM, Ravi [EMAIL PROTECTED] wrote: Hi: I have a integer field in a form. I want this field to be populated with a number when a record is created and the number increasing by 1 for each new record. Like a sequence generator. Is there something out-of-box field? or do I have to build some workflow for this to happen? TIA Ravi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Integer field sequence number
Ravi, Look at $LASTID$ keyword or the nextid field found in arschema. Brian -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Monday, June 23, 2008 12:43 PM To: arslist@ARSLIST.ORG Subject: Integer field sequence number Hi: I have a integer field in a form. I want this field to be populated with a number when a record is created and the number increasing by 1 for each new record. Like a sequence generator. Is there something out-of-box field? or do I have to build some workflow for this to happen? TIA Ravi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Integer field sequence number
Hi Ravi, There's nothing out of the box with the exception of fieldid 1 (EntryID or RequestID depending on the version). You could, however, build a filter with a setfields action that fires only on submit Action: SetFields from SQL select max(fieldname) + 1 from formviewname Value $1$ Thanks, Jonathan Jones Southern Company Services 205-257-4799 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Monday, June 23, 2008 2:43 PM To: arslist@ARSLIST.ORG Subject: Integer field sequence number Hi: I have a integer field in a form. I want this field to be populated with a number when a record is created and the number increasing by 1 for each new record. Like a sequence generator. Is there something out-of-box field? or do I have to build some workflow for this to happen? TIA Ravi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Integer field sequence number
Another idea is to have a separate form for sequence numbers. You would have to do a submit/delete sequence so that you always maintain one record with the up-to-date sequence number. Gordon Frank Remedy Skilled Professional ITIL V3 Foundation Certified On Jun 23, 2008, at 3:42 PM, Ravi wrote: Hi: I have a integer field in a form. I want this field to be populated with a number when a record is created and the number increasing by 1 for each new record. Like a sequence generator. Is there something out-of-box field? or do I have to build some workflow for this to happen? TIA Ravi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Integer field sequence number
but the field 1 has value like 032|032. I was hoping it will be just 032. [EMAIL PROTECTED] select REQUEST_ID from aradmin.sprint_mns_interfaceview where TRS_TICKET_NUMBER='1124164'; REQUEST_ID --- 032|032 Carey Matthew Black wrote: Ravi, Why not use field 1's value? ( You may have a good reason, but sometimes it helps to know what your trying to do so that the best solution can be approached in the discussion. Instead of just answering the question with a simple. Nothing out of the box that does that, other than field 1.) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Integer field sequence number
It appears that the form you are working with is a Join form. On Join forms field 1 is a combination of the field 1(s) from both of the joined forms with a '|' separator character. If using field 1 from one of the 2 firms in the join works then you could do a set fields using either the LEFT or RIGHT functions to just get the part of the field you want (or use field 1 from one of the forms itself). Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Monday, June 23, 2008 4:00 PM To: arslist@ARSLIST.ORG Subject: Re: Integer field sequence number but the field 1 has value like 032|032. I was hoping it will be just 032. [EMAIL PROTECTED] select REQUEST_ID from aradmin.sprint_mns_interfaceview where TRS_TICKET_NUMBER='1124164'; REQUEST_ID --- 032|032 Carey Matthew Black wrote: Ravi, Why not use field 1's value? ( You may have a good reason, but sometimes it helps to know what your trying to do so that the best solution can be approached in the discussion. Instead of just answering the question with a simple. Nothing out of the box that does that, other than field 1.) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are