Skip to main content
Nintex Community Menu Bar

List Number w 6 digits Sequential Numbering Help

  • July 21, 2020
  • 2 replies
  • 49 views
  • Translate All
Lykan114
Forum|alt.badge.img+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

    Simon Muntz
    Nintex Partner
    Forum|alt.badge.img+23
    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.
    Translate
    We provide Nintex Training & Consulting - https://www.definiti.com.au/
    Lykan114
    Forum|alt.badge.img+1
    • Lykan114
    • Author
    • July 22, 2020

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

     

    Mission accomplished!

    Translate
    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement