https://legacy.forums.gravityhelp.com/topic/can-i-store-a-list-fields-multiple-column-values-into-a-custom-taxonomy Gravity Support Forums Topic: Can I store a list field's multiple column values into a custom taxonomy? en-US Mon, 20 Apr 2026 08:30:42 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/can-i-store-a-list-fields-multiple-column-values-into-a-custom-taxonomy#post-48050 Wed, 01 Feb 2012 18:12:21 +0000 David Smith 48050@https://legacy.forums.gravityhelp.com/ <p>Hi Jacorre,</p> <p>Thanks for sharing your thoughts. Sorry you weren't able to use Gravity Forms in your recent project; however, I'm sure you will find many uses for it in the future. :) </p> https://legacy.forums.gravityhelp.com/topic/can-i-store-a-list-fields-multiple-column-values-into-a-custom-taxonomy#post-46334 Fri, 13 Jan 2012 21:01:40 +0000 jacorre 46334@https://legacy.forums.gravityhelp.com/ <p>David, thanks again for taking the time to help the other day. </p> <p>Sad to say that I had to stop using Gravity Forms, but happy to say that I was able to create my own front end form that files all the fields perfectly and displays correctly in my admin area for my custom post type. </p> <p>I do love Gravity Forms and will probably use it for a different website of mine. </p> <p>I know it was mentioned that changing the field name is not possible due to how the form validates fields, etc. I really think that it should be included as an option. If the name can be defined by the user, I would think that the validation would first check if a name was defined and if not then use the standard name entry. Just my suggestion for future versions.</p> <p>Thanks again! </p> https://legacy.forums.gravityhelp.com/topic/can-i-store-a-list-fields-multiple-column-values-into-a-custom-taxonomy#post-46247 Thu, 12 Jan 2012 17:44:55 +0000 jacorre 46247@https://legacy.forums.gravityhelp.com/ <p>Thanks David for taking the time to work with me on this issue. From my testing, I can see that it will not be possible to get this to work. </p> <p>Once the submitted entry gets filed to the custom post type in pending status, I will then review the information.</p> <p>Two fields will not display on the post screen because I'm using jquery on those fields. The jquery is used to create new rows in the table when the plus sign is clicked. So when displaying those fields, the fields are looking for values stored in the database like I described. </p> <p>The values stored in the database when the gform is submitted isn't in the same format so that's where I run into problems. </p> <p>I may have to scrap the idea of using gravity forms altogether and try creating my own front end form instead to duplicate what I use in the admin area.</p> <p>Or just deal with the fact that two fields don't automatically file to the custom post type and use the email generated from the submission and copy the entries for those two fields in. </p> https://legacy.forums.gravityhelp.com/topic/can-i-store-a-list-fields-multiple-column-values-into-a-custom-taxonomy#post-45927 Mon, 09 Jan 2012 22:12:11 +0000 jacorre 45927@https://legacy.forums.gravityhelp.com/ <p>Let me start from the beginning in case others need help on this as well. I was reviewing the detailed description you provided on list fields here: <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>I have a 4 column list with the following column labels:</p> <p>Column 1: Amount<br /> Column 2: Measurement<br /> Column 3: Ingredient<br /> Column 4: Notes</p> <p>I'm using the Gravity Forms + Custom Post Types plugin. The form is being saved to a custom post type in Pending status and this list field is saving to a custom field called ingredient. </p> <p>Based on what you explained previously about list fields and how they are saved, I was expecting something like the following in the database for the ingredient field:</p> <p>a:5:{i:0;a:4:{s:6:"amount";s:2:"12";s:11:"measurement";s:6:"Ounces";s:10:"ingredient";s:13:"Candy Coating";s:5:"notes";s:5:"White";}i:1;a:4:{s:6:"amount";s:1:"6";s:11:"measurement";s:9:"Teaspoons";s:10:"ingredient";s:10:"Shortening";s:5:"notes";s:0:"";}i:2;a:4:{s:6:"amount";s:3:"1/4";s:11:"measurement";s:8:"Teaspoon";s:10:"ingredient";s:13:"Food Coloring";s:5:"notes";s:5:"Green";}i:3;a:4:{s:6:"amount";s:1:"4";s:11:"measurement";s:0:"";s:10:"ingredient";s:12:"Oreo Cookies";s:5:"notes";s:4:"Mint";}i:4;a:4:{s:6:"amount";s:1:"2";s:11:"measurement";s:8:"Packages";s:10:"ingredient";s:13:"Andes Candies";s:5:"notes";s:24:"4.67 ounces each package";}}</p> <p>Instead, what I'm seeing in the database is:</p> <p>12|Ounces|Candy Coating|White<br /> 6|Teaspoons|Shortening<br /> etc...</p> <p>It's not saving the list field with key/value pairs as one row in the database. Instead it's just saving the values and creating a row for each ingredient. [Just an fyi in case it matters, since I'm filing to a custom post type I don't need the form entry it creates, so I am using a function you provided in another forum post to delete the form entry upon submission.]</p> <p>So when I go to review the custom post type entry, it's not displaying the ingredient field data that was submitted because it's looking for:</p> <p>ingredient[i][amount]<br /> ingredient[i][measurement]<br /> ingredient[i][ingredient]<br /> ingredient[i][notes]</p> <p>Does that help? </p> https://legacy.forums.gravityhelp.com/topic/can-i-store-a-list-fields-multiple-column-values-into-a-custom-taxonomy#post-45924 Mon, 09 Jan 2012 20:37:00 +0000 jacorre 45924@https://legacy.forums.gravityhelp.com/ <p>I apologize. I've been trying to test so many different ways to see if I could get it to work. I have emailed you on your website contact form. </p> https://legacy.forums.gravityhelp.com/topic/can-i-store-a-list-fields-multiple-column-values-into-a-custom-taxonomy#post-45914 Mon, 09 Jan 2012 19:09:56 +0000 David Smith 45914@https://legacy.forums.gravityhelp.com/ <p>Hi Jacore,</p> <p>Sorry buddy, I'm a little lost. Do you have Skype or Google Chat? I think we might be able to clear this one up a little faster via chat. Email me your details. :) </p> https://legacy.forums.gravityhelp.com/topic/can-i-store-a-list-fields-multiple-column-values-into-a-custom-taxonomy#post-45904 Mon, 09 Jan 2012 17:11:07 +0000 jacorre 45904@https://legacy.forums.gravityhelp.com/ <p>Just to recap, I removed previous tries in the functions file for trying to save stuff to the database. I am using the Custom Post Types plugin with Gravity Forms so that I can file the Ingredients field to a custom taxonomy called ingredient. </p> <p>What I'm seeing in the database is not one row of data for multiple fields:</p> <p>1|Cup|Salt|Notes<br /> 1|Cup|Sugar|Notes</p> <p>It is one row per list field row. Is there a way to file it as one row of data for all entries of the ingredients list? </p> <p>Because that is how I'm storing it currently in the database:</p> <pre><code>ingredient[0][amount] = 1 ingredient[0][measurement] = Cup ingredient[0][ingredient] = Sugar ingredient[0][notes] = Some comments ingredient[1][amount] = 2 ingredient[1][measurement] = Cups ingredient[1][ingredient] = Flour ingredient[1][notes] = Some comments</code></pre> https://legacy.forums.gravityhelp.com/topic/can-i-store-a-list-fields-multiple-column-values-into-a-custom-taxonomy#post-45789 Sat, 07 Jan 2012 22:19:27 +0000 jacorre 45789@https://legacy.forums.gravityhelp.com/ <p>Sorry to keep posting but I'm not seeing what you describe as the keys/values for a multiple column list field. It appears that upon filing, the data is not serialized? So if I enter two rows of ingredients, I see the following in the database:</p> <p>1|Cup|Salt|Notes<br /> 1|Cup|Sugar|Notes</p> <p>I'm expecting something like:</p> <p>a:5:{i:0;a:4:{s:6:"amount";s:2:"12";s:11:"measurement";s:6:"Ounces";s:10:"ingredient";s:13:"Candy Coating";s:5:"notes";s:5:"White";}i:1;a:4:{s:6:"amount";s:1:"6";s:11:"measurement";s:9:"Teaspoons";s:10:"ingredient";s:10:"Shortening";s:5:"notes";s:0:"";}i:2;a:4:{s:6:"amount";s:3:"1/4";s:11:"measurement";s:8:"Teaspoon";s:10:"ingredient";s:13:"Food Coloring";s:5:"notes";s:5:"Green";}i:3;a:4:{s:6:"amount";s:1:"4";s:11:"measurement";s:0:"";s:10:"ingredient";s:12:"Oreo Cookies";s:5:"notes";s:4:"Mint";}i:4;a:4:{s:6:"amount";s:1:"2";s:11:"measurement";s:8:"Packages";s:10:"ingredient";s:13:"Andes Candies";s:5:"notes";s:24:"4.67 ounces each package";}} </p> https://legacy.forums.gravityhelp.com/topic/can-i-store-a-list-fields-multiple-column-values-into-a-custom-taxonomy#post-45754 Sat, 07 Jan 2012 00:27:52 +0000 jacorre 45754@https://legacy.forums.gravityhelp.com/ <p>Fixed the issue with the thank you message after submitting. </p> <p>Just trying to understand how to make the inner array keys go to lowercase? Do you happen to have a function that would help? </p> <p>I can see that the data is filing to the database but just not with the lowercase keys. We are so close! </p> https://legacy.forums.gravityhelp.com/topic/can-i-store-a-list-fields-multiple-column-values-into-a-custom-taxonomy#post-45751 Fri, 06 Jan 2012 21:36:07 +0000 jacorre 45751@https://legacy.forums.gravityhelp.com/ <p>Ok I tested this online:</p> <pre><code>$a=array(array(&quot;Amount&quot;=&gt;&quot;1&quot;,&quot;Measurement&quot;=&gt;&quot;Cup&quot;,&quot;Ingredient&quot;=&gt;&quot;Sugar&quot;,&quot;Notes&quot;=&gt;&quot;Some text&quot;)); print_r(array_change_key_case($a,CASE_LOWER));</code></pre> <p>And it didn't work. It stays as upper case. I think it's because of an array within an array.</p> <p>So I found a function to help with that:</p> <pre><code>function change_case_recursive($arr){ foreach ($arr as $key=&gt;$val){ if (!is_array($arr[$key])){ $arr[$key]=mb_strtolower($arr[$key]); }else{ $arr[$key]=change_case_recursive($arr[$key]); } } return $arr; }</code></pre> <p>But it's not working. And now I'm having a problem with the form not going to the thank you message after submitting. I was so close! </p>