Skip to main content
Tai & Chyun Admin 님이 #Data Management에 질문했습니다
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.