Lykan114
Nintex Observer

List Number w 6 digits Sequential Numbering Help

Hi, I need help please!

I have a user that needs a number field to have 6 numbers and with each new list item that he creates it needs to be a new/unique number.

 

So item one should be 000001, item two should be 000002, etc.

 

It can't be combined with the ID or anything, it needs to be a new and unique number for each new item that he creates in the list.

Does anyone have any suggestions or examples of this?

 

Thanks for any info/input!

0 Kudos
Reply
2 Replies
SimonMuntz
Nintex Employee
Nintex Employee

Re: List Number w 6 digits Sequential Numbering Help

Hi,

The only way would be to have the numbers stored somewhere and when the form is opened in new mode the next available number is retreived and marked as taken.
A simple way to do this would be to store the numbers in a database and then grab the next one and delete it using a stored procedure and the SQL Request control.
0 Kudos
Reply
Lykan114
Nintex Observer

Re: List Number w 6 digits Sequential Numbering Help

I was able to complete this request by setting up variables in the workflow and a math operation and update item.

 

Mission accomplished!

0 Kudos
Reply