Change custom field from integer to text?

[swcramer]

We originally created a custom lead field as type integer.

We store an 8 digit id number in it. However, it formats it wherever you view it with commas. Since we don't use it as an actual integer, I'd like to just convert the field to text.

I did a test and changed the field in the MySQL table leads_cstm from integer to varchar BUT it doesn't do anything within SugarCRM. Studio still lists the value as integer and all the values are still formatted with commas.

Any ideas?

[Angel]

You need to update the field's definition within the fields_meta_data table.

Alternatively, make a new text field, copy the data from the old field into it, then simply delete the old field.

[swcramer]

Thanks!

I edited the value for the custom field in the fields_meta_data table and I also changed the value for the field in leads_cstm table. Then I did a repair/rebuild. Everything is fixed the way I want it.

-Scott