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 · Jul 30, 2014

Related articles

Comments

3 comments

Date Votes
  • Matt Bowman
    Derrick Kotlus commented  ·  July 30, 2014 5:58 PM  · 

    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
  • Matt Bowman
    Jim commented  ·  February 22, 2016 3:15 PM  ·  

    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
  • Matt Bowman
    Mike commented  ·  July 18, 2016 11:22 AM  ·  

    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