When you edit a custom field and change the field type, the data that you have previously entered in that field is preserved whenever possible.
If you change the field type to a fundamentally different field type, existing data you had entered in that field is deleted. A warning message displays when you make a change. For example, changing a phone number field to a rich text field would preserve your data, whereas changing a rich text field to a percent field would not.
If you change the source list for a list/record field or a multiple select field, existing data in that field is not preserved. A warning message displays when you make a change.
The following table lists supported field type conversions.
|
From Field Type |
To Field Type |
Notes |
|---|---|---|
|
Integer Number |
Value rounded to 0 decimal numbers. |
|
Currency |
Value rounded to 2 decimal numbers. |
|
Integer |
|
Converted without change. |
|
Currency |
|
Converted without change. |
|
Decimal |
Percent |
Converted without change. |
|
Percent |
Decimal |
Converted without change. |
|
|
Check Box is converted as follows:
|
|
Select |
Multiple Select |
List/Record type field remains unchanged. For example, you cannot change from Account to Customer. |
|
|
Converted without change. |
|
Date |
Date/Time |
Date/Time is the date and time in the user’s current time zone and is converted. |