Change field type from text field to text area?

SuiteCRM Forum - English Language SuiteCRM Feedback
1

Hi,
I would like to change a text field with a max of 255 characters to a larger text area field, assuming a text area field will hold more characters. Can I do this once I’ve created the text field and it already has data in it?
Thanks!
-Alyx

2

Hi,

Studio unfortunately doesn’t provide a way to change the type of a field. You could perhaps create a new field with the correct type and set up a workflow to copy the field contents over. Alternatively if you have some knowledge of SQL you could change the field type in the fields_meta_data table manually.

If you are making changes like this I would suggest taking a backup just to be safe.

Thanks,
Jim

3

Hi, Thank you for your prompt response; now I know what to do!
-Alyx

4

thanks jim,
i can make it by change from my sql database but can i done it with javascript validation?