Changing Field Type from DropDown to MySQL formula field

[pepe]

Hi Sergey,
I had to change a field from type DropDown to type MySQL formula. There is an issue because fields show values after the change of type. With field type MySQL formula, fields are always emtpy because values are computed dynamically. Please see screen shot.

Also, table app_fields_choices still shows dropdown values after the above change ... there might be some cleanup required after that operation.
Best regards, Pepe

[support]

I allowed change field type because some times it needs change from dropdown to multidropdown and do not lost data.
But in your case you better delete field and create new one.