PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Mass Change of Multiple Choice Fields to Checkbox Style in mySQL

  1. Anonymous
    Unregistered

    When creating a form last night I accidentally entered a large number of fields (with a lot of choices in each) as Multiple Choice rather than Checkbox style fields. It would take me a very long time to re-enter all of these so I'm hoping for another solution, specifically I'm hoping I can edit the mySQL data and change the field type.

    I've located the "display_meta" field in the wp_rg_form_meta table in mySQL and tried mass replacing the string "radio" with "checkbox" but that didn't seem to do it and caused the form not to load correctly. I have a backup that I can replace the original field data with to get it back to working, but I'm still hoping to be able to fix this without a massive re-entry of form fields.

    If anyone knows what I need to change in the mySQL field to change these instances of multiple choices (which are the only ones in this field, which would make search and replace easy in this case once the items are identified that need replacing) to checkboxes I'd really appreciate any info.

    Posted 13 years ago on Monday January 31, 2011 | Permalink
  2. EDIT:

    Looking at this a little more closely it does not appear you can just change the "radio" to "checkbox" and change the length of the serialized data. There's more to it than that, from looking at the form_meta. The post I made previously will not help you.

    Posted 13 years ago on Monday January 31, 2011 | Permalink
  3. Anonymous
    Unregistered

    OK, well thanks anyway for looking into it. Any admins have an idea as to how to do this? I really need to get this working but am loathe to have to re-do it from scratch...hoping there's a way to avoid this.

    Posted 13 years ago on Tuesday February 1, 2011 | Permalink
  4. Hi Sean,

    The easiest way to do this is to export the form, change the field type ("radio" to "checkbox") in the XML and re-import. You will lose any entries submitted against the old form, but it sounds like this is a new form so hopefully that won't be an issue.

    Posted 13 years ago on Tuesday February 1, 2011 | Permalink
  5. Anonymous
    Unregistered

    Thanks David, just what I needed!

    Posted 13 years ago on Tuesday February 1, 2011 | Permalink
  6. Anonymous
    Unregistered

    .

    Posted 13 years ago on Tuesday February 1, 2011 | Permalink
  7. Anonymous
    Unregistered

    Never mind my last, the problem went away, seems to have been a temp JS bug or something....

    Posted 13 years ago on Tuesday February 1, 2011 | Permalink