Hi All,
I am planning to generate a Dynamic ID Which increments by 1 for Every record.
For first record its 1 and goes on for next record 2 and then 3 and so on.

Any ideas.

Yes, use the Request ID field or an Oracle sequence.

Thanks for the reply. I know Request ID is the unique iD but i also need an other field which has the unique id and gets an Increment of 1 for every new record.

I have created a integer field for this purpose and a filter which increments every time when submitted but it always shows up 1 with it.

Thanks in Advance

Any Ideas.

Yes, a SQL sequence...

Cant we do it using a Remedy Workflow.

Yes, using a set field. Try to set by filter your field by the value of the Request ID field at submit time.

I tried this but it doen't work.
Here is the Workflow
Filter
Execute on Submit
1) Set fields
Current transaction
ID = Request ID

OTher way tried

2) Set fields
from that form
Request ID != NULL
ID = Request ID

I know second option doesnt work as this doesn't have Request ID when submitted but i dont know why 1st not working.Let me know if you have any idea

Any ideas

Waiting if anybody can send there ideas as i have the same issue

Why don't you use the same idea of the arschema form? Try creating a data form with a schema (form) name field and an integer field to hold the last value used for that form. When you create a record in your form (let's call it form 'A' for now), get the current counter value from your new form, bump it up by 1, and push that value back to your counter form (the new one). This will allow you to use the same functionality across multiple forms, if you need to.

Just a thought.

Thank you.

Thank you verymuch I got it.

Thanks,
Baba

Glad to hear it!

U can use GUID

Thanks
Dipti

GUID is the best option if it has not to be visible for users.

If you want create a ID based on Request ID use a filter on submit which does a push field on the form where the qualification is 'Request ID' = $Request ID$. You could set the id within the push field or trigger other workflow (filter) which sets the id.