Answers.Body: <p>My first answer is: yes you can do this in the backend! I just confirmed it: in the <code>civicrm_price_field</code> table find your <code>Price Field ID</code> (row) and then change the <code>html_type</code> from: <code>Radio</code> to: <code>CheckBox</code> I just did this on a dev site and my price/field?action=preview looks just fine - no errors/notices.</p>
  
  <p>My responsible answer is: first make an extra backup - next make a clone of your project and make the edit to the <code>html_type</code> - check your contribution page(s) where you offer this <code>price_set</code> - run any report you would normally run to check to see that everything still adds up [IF you've already had users selecting these price_set fields so you have data in them already].</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-25T18:49:11.963Z
Answers.Text: It is a form that has no data entered into it yet. I received the form from a client in advance, and made a bunch of fields using the wrong field type (changed later). Was hoping to not have to redo all the work. Thank you.
Answers.UserDisplayName: Zachary
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-25T18:58:13.223Z
Answers.Text: Then what I wrote above should work for you! Should take just a few min... if you have phpMyAdmin - it's an easy GUI edit. Let me know if you need some help with the MySQL command (if you need to go that route).
Answers.UserDisplayName: KarinG - Semper IT
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-25T19:06:12.827Z
Answers.Text: It appears to have worked. Thank you. I used PHPMyAdmin which has the quick edit feature.
Answers.UserDisplayName: Zachary
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-25T19:11:40.093Z
Answers.Text: Excellent! Best.
Answers.UserDisplayName: KarinG - Semper IT
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-25T19:19:26.220Z
Answers.Text: Want to take a stab at my next Q? http://civicrm.stackexchange.com/questions/12030/how-to-clone-a-price-set-field-and-its-options :)
Answers.UserDisplayName: Zachary
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-25T19:20:30.117Z
Answers.Text: :-)! I've got to finish some code work - will have a look later though
Answers.UserDisplayName: KarinG - Semper IT
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-11-02T11:41:51.147Z
Answers.Text: Hi @KarinG-SemperIT, I have to change field type of price set which has data to it? should I try it out on dev?
Answers.UserDisplayName: harshal
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-11-02T12:06:54.183Z
Answers.Text: Yes try your specific type edit on dev first and look at your data generating some reports etc. to ensure all is well.
Answers.UserDisplayName: KarinG - Semper IT
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-25T13:49:34.467Z
Answers.LastActivityDate: 2016-05-25T13:49:34.467Z
Answers.UserDisplayName: KarinG - Semper IT
Body: <p>I have some price set fields created as Radio currently, but they need to be Checkbox type. Is there any way to safely change (even in backend) without having to recreate the entire field (there are a lot of choices)</p>
  
  <p>CiviCRM 4.6.x Drupal 7.x</p>
  
  <p>Thanks!</p>
  
Tags: <civievent><price-sets>
Title: How to Change Price Set Field Type without deleting and re-adding
ThreadText: # How to Change Price Set Field Type without deleting and re-adding
  
  (Asked by: username_0 on 2016-05-24)
  
  I have some price set fields created as Radio currently, but they need to be Checkbox type. Is there any way to safely change (even in backend) without having to recreate the entire field (there are a lot of choices)
  
  CiviCRM 4.6.x Drupal 7.x
  
  Thanks!
  
  **Tags:** civievent, price-sets
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-05-25. Score: 2 | Accepted answer
  
  My first answer is: yes you can do this in the backend! I just confirmed it: in the `civicrm_price_field` table find your `Price Field ID` (row) and then change the `html_type` from: `Radio` to: `CheckBox` I just did this on a dev site and my price/field?action=preview looks just fine - no errors/notices.
  
  My responsible answer is: first make an extra backup - next make a clone of your project and make the edit to the `html_type` - check your contribution page(s) where you offer this `price_set` - run any report you would normally run to check to see that everything still adds up [IF you've already had users selecting these price\_set fields so you have data in them already].
  
  > **Comments:**
  > **username_0**: It is a form that has no data entered into it yet. I received the form from a client in advance, and made a bunch of fields using the wrong field type (changed later). Was hoping to not have to redo all the work. Thank you.  
  > **username_1**: Then what I wrote above should work for you! Should take just a few min... if you have phpMyAdmin - it's an easy GUI edit. Let me know if you need some help with the MySQL command (if you need to go that route).  
  > **username_0**: It appears to have worked. Thank you. I used PHPMyAdmin which has the quick edit feature.  
  > **username_1**: Excellent! Best.  
  > **username_0**: Want to take a stab at my next Q? http://civicrm.stackexchange.com/questions/12030/how-to-clone-a-price-set-field-and-its-options :)  
  > **username_1**: :-)! I've got to finish some code work - will have a look later though  
  > **username_2**: Hi @username_1, I have to change field type of price set which has data to it? should I try it out on dev?  
  > **username_1**: Yes try your specific type edit on dev first and look at your data generating some reports etc. to ensure all is well.  
  
  ---
  
  