Skip to main content
When I want to channge the Order Number, the following description show up in the system:

 

Enter the details for the Auto Number field. Note that changes to the Display Format apply only to records created after the change.

 

Then, is there a way I can change the number of the records before the change? 

 

For example, before the change the order number are 378-398, can I change them to be 1-21?
3 件の回答
  1. 2016年1月12日 10:52
    Hello Jeffrey,

     

    To achieve this result, it will be necessary to:

     

    1. Change the Field Type of the custom field from Auto-Number to Text, so the field values can be updated.

     

    2. Use the Data Loader to extract all records from the object, including the record Id's and the auto-number field in the export.

     

    3. Open the export file in Excel and update the values in the auto-number column as desired.

     

    4. Use the Data Loader to mass update the existing records using the file you have prepared.

     

    5. Change the Field Type of the custom field back to Auto-Number. Be sure to set the value for the "Starting Number" higher than the highest existing auto-number on your existing records to prevent duplicate numbers from being generated.
0/9000