[SOLVED] Custom starting # for Auto-Increment Field

#1

I’d like to be able to choose a custom starting number for the auto-incrementing number field - I have existing records that already have a unique ID # associated with them, but they don’t start at 1.

Thanks!

1 Like
Autonumber field
#2

Not sure when, or if, they will implement this - but a workaround would be to combine your existing ID #s with an auto number field to generate a new, combined ID# that auto increments.

For example, if you have your existing ID# starting number, let’s say 100 for the example, you would make an auto number field, and then another new formula field which would look something like this:

        100+{NewAutoNumberField}

Which would then create new auto numbers starting at 101.

Or check this thread from a while back for some ideas in the interim:

#3

That I will do. Thanks!

#4

This doesn’t seem like a good solution, though. This results in numbers 1001 through 1009, and then would begin 10010 through 10019, eventually resulting in 100100 through 100199, etc.

#5

It’s not working through concatenation, it’s working through addition. That’s a math equation, not a string equation.

#6

🤦

Of course… I’m tired! Thanks!

1 Like