Can I increase a custom number field size without loosing data? - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Arlette GeffertArlette Geffert 

Can I increase a custom number field size without loosing data?

I set up a custom number field with a maximum of 6 digits.  When I go in to change the field size, it says if I do that I will lose the data already in the field.  Can it be done for do I need to set up a new field and transfer the data from one to the other?
Salesforce AdministratorSalesforce Administrator
Are you only increasing the size? If so, you shouldn't have to worry about losing data, but it will still give you the error message as a precaution.

If it is that much of a concern you could export the custom field and the objects Id number to a csv file before you change the field size. Then if you find that you did lose some data, you could then update all of your records to go back to the original with the Apex Data Loader. Granted it would be best to do this all while people are not entering records just for the sake of your data integrity.
Arlette GeffertArlette Geffert
Thanks Andrew.  I will export the info first to save it then make the change.