How can I change the filed type?

11 years 4 months ago #152409 by sonservant
How can I change the filed type? was created by sonservant
Hello,
I created a custom filed, "Number of employees" and selected "checkbox (multiple). I saved the filed and then didn't like the way it looked in the registration form.
I went to edit the field and change it to "dropdown (multi-select)" but the dropdown to select field type is grayed out.
How can the field type be changed after it is saved?
Thanks.

Please Log in to join the conversation.

11 years 4 months ago #152421 by nant
Replied by nant on topic Re: How can I change the filed type?
If you can its best to just remove the old field and create a new one.

If you know what you are doing you can use phpmyadmin to find the relevant row in your comprofiler_fields table and modify the type column from multicheckbox (which is the type for the checkbox(multiple)) to multiselect (which is the type for dropdown (multi-select)).

Make sure you backup your database before attempting such changes.

Please Log in to join the conversation.

11 years 3 months ago #152452 by sonservant
Replied by sonservant on topic Re: How can I change the filed type?
Thanks nant.
Out of curiosity, why is the GUI option locked after a save?

Please Log in to join the conversation.

11 years 3 months ago #152456 by nant
Replied by nant on topic Re: How can I change the filed type?

sonservant wrote: Thanks nant.
Out of curiosity, why is the GUI option locked after a save?


Because the data structure depends on the field type.

You cannot convert a text field to an integer field and vice versa.
Or an image field to a text field.

Its locked for your protection.

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.147 seconds

Facebook Twitter LinkedIn