Changing a custom client field from drop down to checkbox

[rocconeri]

Hello,

 

I have a Client Custom Field in the registration form set as drop down menu, and I would like to change it to checkbox, but I don't want to lose all previous data. So all the old data should be kept as drop down, and all the new data should be saved as checkbox. Is it possible to achieve this?

 

Or alternatively, since the drop down menu has 2 choices (one empty, and one "I Accept"), convert the empty choices to a "disabled" checkbox, and all "I Accept" choices to a "enabled" checkbox.

 

Thank you for your help.

 

Rocco

[brian!]

there is always a third option of creating a new Custom Client field as a checkbox and ticking the "Show On Order Form" checkbox, and then in the existing Custom Client field setup, unticking the "Show on Order Form" checkbox.

 

that way, you should be able to keep your existing data from the current custom field for those clients who have used it, and for new clients from this point on, their profiles will show only the new checkbox value - as they will only see the new checkbox when registering and not the old dropdown.

[rocconeri]

I already considered the option of creating a new Custom Client Field and disable the old one from order form, but I would prefer to completely replace the old field, in order to have just one Custom Field to avoid confusion, and to not have 2 similar Custom Fields shown in the Client's profile (at admin side). Or, is there a way to hide a Custom Client Field in client's profile (at admin side)?

[brian!]

it's not as easy to modify the admin side as it is the client side (unless what you want to change is in the admin templates or css) - it would be easy to remove the custom fields from the client side (any or all).

 

if you want to just have one custom field, then you could create a second custom field (checkbox) - but run a sql query (on tblcustomfieldsvalues table I think) to populate its values based on the value of the dropdown field.

 

for "I accept" (Enabled), the value will be "on", otherwise it would be blank.

 

if you're unfamiliar with sql queries, then do not attempt to use it on your live database - and even if you are familiar, make a backup of it first!