Question

Auto Numbering not in order

0

Hi, I have been using auto numbering where the objects are committed in a microflow. The numbering is in sequence when the “Save changes” button is used, but the numbering changes when I use a microflow. I’ve attached a screenshot of my workflow below. Is there something that I’m missing out on? This is how the IDs are auto numbered. Thanks.

asked 2020-12-01

Sherlin Susanna Shaji

3 answers

0

The above is my create object microflow. This opens a form into which I enter the details, then I call the below microflow:

Am I doing this right?

answered 2020-12-02

Sherlin Susanna Shaji

Stella D · Accepted Answer · 2020-12-02

Hi Sherlin,

I hope you are using Auto Number for your ticket ID attribute.

In that case, for example if you created an object for ticket but you are not saving in to the database, then also Auto numbering will happen.

When you create ticket object for second time, the number will be 2 for ticket id instead of 1 even though you did not saved the first object in to the database.

Because of this you are getting incorrect sequence. Use integer datatype for ticket ID attribute

Lennart Spaans · Accepted Answer · 2020-12-01

As far as I know Autonumbers won't necessarily be created in sequence. They are merely a way to have unique numbers in your database. Use a sorting attribute like an integer or a datetime if you want to make sure you have a sequence.