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



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].

  • 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.
    – Zachary
    May 25 '16 at 18:49
  • 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). May 25 '16 at 18:58
  • It appears to have worked. Thank you. I used PHPMyAdmin which has the quick edit feature.
    – Zachary
    May 25 '16 at 19:06
  • Excellent! Best. May 25 '16 at 19:11
  • Want to take a stab at my next Q? civicrm.stackexchange.com/questions/12030/… :)
    – Zachary
    May 25 '16 at 19:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.