Skip to main content

Set starting number for auto counter?

Scott Carpenter
  • Updated

I have an existing auto incremented ID in my data, how do I set the starting point for an auto incremented field?

 

Chris Meyer shared this idea · 

Comments

3 comments

Date Votes
  • Permanently deleted user
    Derrick Kotlus commented  ·    · 

    Hello Chris,

    The number the auto counter starts at can be changed in your table builder. After clicking on the field in the center column, you will be presented with an option to chose a starting number.

    Hope this helps!

    Derrick

    0
  • Permanently deleted user
    Jim commented  ·    ·  

    I started my Auto Counter at 16001, but on the seven records I've put in the table show the counter numbers: 16003, 16004,16005, 16024, 16025, 16026, 16027.

    I don't know why it goes to these numbers, I tried starting them a 1 and 15001 and it does the same number pattern?

    0
  • Permanently deleted user
    Mike commented  ·    ·  

    Derrick,
    Changing the number in the table builder does nothing. The auto counter continues from wherever it last left off. (Like it is being tracked by SQL or some other process).
    I had the same issue. When importing data from the "classic" system, I tried to continue the numbers where the old system left off, didn't work.
    Mike

    0

Please sign in to leave a comment.

Powered by Zendesk