Question

A property management company has a custom field called Property_Status__c on the Property object that was created as a Text field. Sales users have been typing values freely, resulting in inconsistent entries like 'Available', 'available', and 'AVAIL'. The administrator wants to convert this field to a Picklist to standardize future entries. What should the administrator be most aware of before performing this field type change?

Accepted Answer

Existing text values that do not match a defined picklist value will remain in the records but may appear as inactive or non-restricted values, so the data should be cleaned or mapped before conversion.

Answer

Changing a Text field to a Picklist is not permitted in Salesforce; the field must be deleted and recreated as a new Picklist field.

Answer

The conversion will automatically standardize all existing values to match the closest defined picklist value with no data loss.

Answer

Converting to a Picklist requires the field first be changed to a Master-Detail relationship to preserve referential integrity.