thinkamap Gravity Support Forums User Favorites: thinkamap en-US Sat, 04 Apr 2026 10:19:00 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/list-fields-and-the-database-2-part-question#post-49414 Tue, 14 Feb 2012 13:30:01 +0000 David Smith 49414@https://legacy.forums.gravityhelp.com/ <p>Hi Brad,</p> <p>Here is a brief run down on how list field data is stored:</p> <p><a href="http://www.gravityhelp.com/forums/topic/list-field-help" rel="nofollow">http://www.gravityhelp.com/forums/topic/list-field-help</a></p> <p>You will see from <a href="http://grab.by/bb31" rel="nofollow">this example</a> (index 6) how the data is stored in a serialized array as the value for a single field in the database. The thread above also provides details on how to unserialize this data and what format it will be in after it is unserialized.</p> <p>For your second question, short answer is no. You'll be fine. :) </p> https://legacy.forums.gravityhelp.com/topic/list-fields-and-the-database-2-part-question#post-48805 Thu, 09 Feb 2012 04:33:08 +0000 Brad-sd 48805@https://legacy.forums.gravityhelp.com/ <p>I have two database questions. First I just want to say that I'm not an expert with databases. I know just enough to figure things out and get what I need done (usually in the least efficient way). I'm not familiar enough to go into the guts of WordPress to view the actual database setup.</p> <p>Question #1</p> <p>I am trying to figure out how "List Field" entries are handled in the database. Each element (column : row) does not seem to have a dedicated field.</p> <p>I need to export form entries and add them to an offline database for further analysis and manipulation. I am having trouble with list fields. For instance, I have one that is three columns and up to ten rows (a1:c10). From what I can tell, when exported, the completed field will show something like this: ROW 1 (1|2|3). If one of the columns if left blank, I would have expected: ROW 1 (1||3). Instead, unused columns and unused rows are ignored in the export: ROW 1 (1|3).</p> <p>I understand why it is done this way, but I'm wondering how this is handled in the WordPress database. </p> <p>I'm sure I can create a small program to take the export file, process the data in a way that it can be successfully imported to my offline database. I was just hoping to eliminate that extra step.</p> <p>-------------</p> <p>Question #2</p> <p>I have several small forms, and one large (88 fields) form. Since the forms share the same database as our WordPress install, does our database become more vulnerable to errors with many and/or large forms? </p> https://legacy.forums.gravityhelp.com/topic/list-field-export-delimeter#post-47829 Mon, 30 Jan 2012 18:05:24 +0000 mdthomann 47829@https://legacy.forums.gravityhelp.com/ <p>First of all, great product and excellent support forums!</p> <p>When I export entries for a form with a "list" field, it exports the field with a "|" pipe delimiter. Can I change this? I presume it is in export.php somewhere but wasn't able to find it.</p> <p>Thanks! </p> https://legacy.forums.gravityhelp.com/topic/list-field-help#post-39913 Thu, 03 Nov 2011 14:33:58 +0000 David Smith 39913@https://legacy.forums.gravityhelp.com/ <p>My pleasure. :) </p> https://legacy.forums.gravityhelp.com/topic/list-field-help#post-39904 Thu, 03 Nov 2011 13:59:01 +0000 SqueezeDigltal 39904@https://legacy.forums.gravityhelp.com/ <p>Excellent crash course! Thanks. </p> https://legacy.forums.gravityhelp.com/topic/list-field-help#post-39885 Thu, 03 Nov 2011 12:34:54 +0000 David Smith 39885@https://legacy.forums.gravityhelp.com/ <p>Hi Squeeze,</p> <p>Quick crash course on the list fields. :)</p> <p><a href="http://grab.by/bb32" rel="nofollow">Submitting this</a> will give you <a href="http://grab.by/bb31" rel="nofollow">this (index "6")</a> in the <strong>$entry</strong> object. Using the <a href="http://php.net/manual/en/function.unserialize.php" rel="nofollow">unserialize()</a> function on that $entry value (<a href="http://pastie.org/2805301" rel="nofollow">like so</a>) will give you a <a href="http://grab.by/bb34" rel="nofollow">nice array broken down by column</a>.</p> <p>Also, as of v1.6 we're officially recommending you use the <a href="http://www.gravityhelp.com/documentation/page/Gform_after_submission" rel="nofollow">gform_after_submission</a> for places you would have previously used the <a href="http://www.gravityhelp.com/documentation/page/Gform_post_submission" rel="nofollow">gform_post_submission</a> hook. Short story is there were some inconsistencies with how the previous hook was processed. The new hook resolves those issues. :) </p> https://legacy.forums.gravityhelp.com/topic/list-field-help#post-39882 Thu, 03 Nov 2011 12:21:26 +0000 SqueezeDigltal 39882@https://legacy.forums.gravityhelp.com/ <p>Hi,<br /> When usinf the list field 2 columns, 1 row both of the input boxes have the same name. How can i target them seperately for use in gform_post_submission?<br /> Thanks. </p>