Dynamic ID Numbers

[kpcollier]

Hello. I am trying to create a somewhat dynamic ID number for my records. Here is how my workflow goes:

We are a construction company. When we get a job, we make orders for materials for that job. There may be multiple orders for one job. Each Job on our Job_Table gets a Job Number (ex. 12345). I am trying to use this job number for the basis of my Order ID: I want the Job Number followed by the number of order this is for the job. 

So, lets say the Job # is 12345. We have to make 3 separate orders for this job. I would want the IDs to be 12345-1, 12345-2, 12345-3. 

Is this possible? If more information is needed please ask.

Thank you.

[Vitalikssssss]

Hi @kpcollier,

You should consider using Triggered action for this type of ID generation. 

Your Trigger should be based on Order table and should update the #inserted.

Also, you need to have on field to store a sequence number of the Order.

You can import attached examples to find more about the Trigger.

Hope this helps.

Regards,

vitalikssssss

Dynamic_ID_number_1_0_2019-Sep-05_1359.zip