Find your content:

Search form

You are here

How do I set the startpoint for an autonumber after field creation?

 
Share

Just as the title asks, how do I set the startpoint for an autonumber after field creation? The field is an external Id and to avoid conflict with the external system, I need to move the id up a few numbers.


Attribution to: Bob Roberts

Possible Suggestion/Solution #1

You can convert the field type to text, then convert it back to auto number. When you convert it back, you'll have the option to set the starting number again. I might do this after hours if there is a danger of a record being created while you're doing the field conversion.

https://help.salesforce.com/HTViewSolution?id=000005195&language=en_US


Attribution to: Carolyn Grabill

Possible Suggestion/Solution #2

Changing the field type is a good idea. Alternately, if you're only going to move the auto-number up by a few numbers or even a few tens of numbers, you could insert some records and delete them. Crude but effective.


Attribution to: Vin D'Amico
This content is remixed from stackoverflow or stackexchange. Please visit https://salesforce.stackexchange.com/questions/660

My Block Status

My Block Content