The purpose of this article is to provide information about suggestions when changing the field type of the column
Generally, It is highly recommended to avoid changing the type of a column. Experience has shown that a better approach is to create a new column with the new data type and copy the data from old column to the new column
Steps to follow to change the data type
1. Create a new column with the new datatype
2. Copy the data from the old column to the new column
3. Rename the original column label
This is all so as not to break customer customizations and avoid loss of data.