https://legacy.forums.gravityhelp.com/topic/mass-change-of-multiple-choice-fields-to-checkbox-style-in-mysql Gravity Support Forums Topic: Mass Change of Multiple Choice Fields to Checkbox Style in mySQL en-US Mon, 20 Apr 2026 03:29:22 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/mass-change-of-multiple-choice-fields-to-checkbox-style-in-mysql#post-17412 Tue, 01 Feb 2011 13:19:16 +0000 Anonymous 17412@https://legacy.forums.gravityhelp.com/ <p>Never mind my last, the problem went away, seems to have been a temp JS bug or something.... </p> https://legacy.forums.gravityhelp.com/topic/mass-change-of-multiple-choice-fields-to-checkbox-style-in-mysql#post-17411 Tue, 01 Feb 2011 13:12:37 +0000 Anonymous 17411@https://legacy.forums.gravityhelp.com/ <p>. </p> https://legacy.forums.gravityhelp.com/topic/mass-change-of-multiple-choice-fields-to-checkbox-style-in-mysql#post-17410 Tue, 01 Feb 2011 13:10:37 +0000 Anonymous 17410@https://legacy.forums.gravityhelp.com/ <p>Thanks David, just what I needed! </p> https://legacy.forums.gravityhelp.com/topic/mass-change-of-multiple-choice-fields-to-checkbox-style-in-mysql#post-17403 Tue, 01 Feb 2011 12:04:40 +0000 David Smith 17403@https://legacy.forums.gravityhelp.com/ <p>Hi Sean,</p> <p>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. </p> https://legacy.forums.gravityhelp.com/topic/mass-change-of-multiple-choice-fields-to-checkbox-style-in-mysql#post-17371 Tue, 01 Feb 2011 02:01:55 +0000 Anonymous 17371@https://legacy.forums.gravityhelp.com/ <p>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. </p> https://legacy.forums.gravityhelp.com/topic/mass-change-of-multiple-choice-fields-to-checkbox-style-in-mysql#post-17335 Mon, 31 Jan 2011 16:35:39 +0000 Chris Hajer 17335@https://legacy.forums.gravityhelp.com/ <p>EDIT:</p> <p>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. </p> https://legacy.forums.gravityhelp.com/topic/mass-change-of-multiple-choice-fields-to-checkbox-style-in-mysql#post-17317 Mon, 31 Jan 2011 14:41:48 +0000 Anonymous 17317@https://legacy.forums.gravityhelp.com/ <p>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.</p> <p>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. </p> <p>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. </p>