List Number w 6 digits Sequential Numbering Help

  • 21 July 2020
  • 2 replies
  • 16 views
Lykan114
Badge +1

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!

2 replies

SimonMuntz
Userlevel 6
Badge +22
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.
Cool Nintex courses: https://learn.nintex.com/
Lykan114
Badge +1

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

 

Mission accomplished!

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings