How can I change the filed type?
- sonservant
- OFFLINE
-
Junior Member
- Posts: 20
- Thanks: 0
- Karma: 0
13 years 2 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.
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.
nant
Team Member- OFFLINE
- Posts: 25531
- Thanks: 1834
- Karma: 877
13 years 2 months ago #152421
by nant
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
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.
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.
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
Please Log in to join the conversation.
- sonservant
- OFFLINE
-
Junior Member
- Posts: 20
- Thanks: 0
- Karma: 0
13 years 2 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?
Out of curiosity, why is the GUI option locked after a save?
Please Log in to join the conversation.
- nant
- Team Member
- OFFLINE
- Posts: 25531
- Thanks: 1834
- Karma: 877
13 years 2 months ago #152456
by nant
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.
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
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.
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
Please Log in to join the conversation.
Moderators: beat, nant, krileon
Time to create page: 0.206 seconds
-
You are here:
- Home
- Forums
- Archive
- Advanced Members Support
- How can I change the filed type?