Integer field sequence number

2008-06-23 Thread Ravi
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

Re: Integer field sequence number

2008-06-23 Thread Carey Matthew Black
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.)

Re: Integer field sequence number

2008-06-23 Thread Brian Gillock
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

Re: Integer field sequence number

2008-06-23 Thread Jones, Jonathan Clark
$ 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

Re: Integer field sequence number

2008-06-23 Thread Gordon Frank
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

Re: Integer field sequence number

2008-06-23 Thread Ravi
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 ---

Re: Integer field sequence number

2008-06-23 Thread Grooms, Frederick W
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