+11
Hello Guys,
I have been given the NWF file attached, which generates a reference number based on ID.
However, I am unable to reset the ID number 
Therefore, maybe someone can help me to modify the current file as following:
- start counting from 0
- also it should start from 0 for each new year.
e.g 1600001 | 1700001 | 180001
Can you support me please?
+1
I was able to do this creating a new column. Then in workflow that runs when item is created I run a query list to get the highest list id # and then I math operation to add some value like 5000 or whatever. I also do another action and add a prefix to my new column's value. That is a read only field on the form that everybody sees not the list id. This allows you to modify the value added to change where your sequence is in the future, either lower or higher.
+11
hmmm not sure, if you understood my point!!
I do not want the ID number to take into consideration because I cannot reset it.
I rather want it to start "your own index auto-num" based on the year 16 / 17 / 18
example 160001 | 170001 etc.
Anyway, would you be able to share the autonum .nwf file for me to test it?
I have attached mine, see the first message.
Maybe you could modify it ?
+1
You're right, I didn't. However you could still use the idea and use the fn-FormatDate({WorkflowVariable:MyDate}, "yy") and add your # to the end of it. If your date value is today it will give your the current year. I also attached my wf file.
Hi
I am still a "beginner", but I am trying to build a WF exactly like you described (user submit a change request via form. After "submit", WF needs to auto generate a "Req#"). Any chance could you provide a screenshot of the configurations for your steps? THANKS!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.