SugarCRM Fields, Changing Field Types

sugarcrmdevelopers —  December 17, 2012

I don’t share this fact often, but SugarCRM fields can change types if you do it from the database. Assuming there are no vardefs specifying otherwise, here’s how I converted a set of dropdown (enum) fields to open-text (varchar) fields…

Caution, though! You can lose data if your change data types or shorten a field in a live database. Use your head. There’s a reason the SugarCRM Studio doesn’t do this for you.