[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!


#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!