https://legacy.forums.gravityhelp.com/topic/gform_pre_render-help Gravity Support Forums Topic: Gform_pre_render help en-US Tue, 21 Apr 2026 17:29:05 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/gform_pre_render-help#post-346326 Wed, 26 Jun 2013 17:03:00 +0000 gtm1ldy 346326@https://legacy.forums.gravityhelp.com/ <p>Please close this topic. I figured it out. This is as simple as it gets and will help you do more advanced selections with GForms. I've seen a few questions for this over the last 2 years with no responses. </p> https://legacy.forums.gravityhelp.com/topic/gform_pre_render-help#post-346304 Wed, 26 Jun 2013 16:38:07 +0000 gtm1ldy 346304@https://legacy.forums.gravityhelp.com/ <p>OK. I have it narrowed down, I can manuall add choices but cannot retreive table data. Here is where I am at.</p> <p>add_filter("gform_pre_render_5", populate_dropdown);<br /> add_filter("gform_admin_pre_render_5", populate_dropdown);</p> <p>function populate_dropdown($form){<br /> global $wpdb;</p> <p> $results = $wpdb-&gt;get_row("SELECT btc_state_short from btc_state_list");<br /> $choices = array();<br /> $choices[] = array("text" =&gt; "2323", "value" =&gt; "2323");</p> <p>// This is where I am stuck<br /> foreach ($results as $result) {<br /> $choices[] = array("value" =&gt; $result-&gt;value, "text" =&gt; $result-&gt;value);<br /> }</p> <p> foreach($form["fields"] as &amp;$field){</p> <p> if($field["id"] == 1){<br /> $field["choices"] = $choices;<br /> }<br /> }</p> <p> return $form;<br /> } </p> https://legacy.forums.gravityhelp.com/topic/gform_pre_render-help#post-346263 Wed, 26 Jun 2013 15:51:47 +0000 gtm1ldy 346263@https://legacy.forums.gravityhelp.com/ <p>I cannot narrow this one down and am looking for your support. </p> https://legacy.forums.gravityhelp.com/topic/gform_pre_render-help#post-346251 Wed, 26 Jun 2013 15:38:17 +0000 David Peralty 346251@https://legacy.forums.gravityhelp.com/ <p>Can you isolate the issue by filling the items array manually with some values to test to see if that part of your code is working as expected? </p> https://legacy.forums.gravityhelp.com/topic/gform_pre_render-help#post-346244 Wed, 26 Jun 2013 15:31:56 +0000 gtm1ldy 346244@https://legacy.forums.gravityhelp.com/ <p>Hello,</p> <p>This documentation is for checkbox selections. Below is my code, it will not return the States from the table. Help would be greatly appreciated?</p> <p>add_filter("gform_pre_render_5", populate_dropdown);<br /> add_filter("gform_admin_pre_render", populate_dropdown);</p> <p>function populate_dropdown($form){<br /> global $wpdb;</p> <p> if($form["id"] != 5)<br /> return $form;</p> <p> $mytable = $wpdb-&gt;btc_state_list;<br /> $q = "SELECT btc_state_short from $mytable";<br /> $results = $wpdb-&gt;get_results($q);</p> <p> $items = array();<br /> $items[] = array("text" =&gt; "", "value" =&gt; "");</p> <p> foreach ($results as $result) {<br /> $items[] = array("value" =&gt; $results-&gt;state, "text" =&gt; $results-&gt;state);<br /> }</p> <p> foreach($form["fields"] as &amp;$field){<br /> if($form ["id"] == 1){<br /> $field["choices"] = $items;<br /> }<br /> }</p> <p> return $form;<br /> } </p> https://legacy.forums.gravityhelp.com/topic/gform_pre_render-help#post-346214 Wed, 26 Jun 2013 14:39:23 +0000 David Peralty 346214@https://legacy.forums.gravityhelp.com/ <p>Sorry, wrong documentation page. <a href="http://www.gravityhelp.com/documentation/page/Gform_field_choices" rel="nofollow">http://www.gravityhelp.com/documentation/page/Gform_field_choices</a> Is what you require. </p> https://legacy.forums.gravityhelp.com/topic/gform_pre_render-help#post-346184 Wed, 26 Jun 2013 14:21:29 +0000 gtm1ldy 346184@https://legacy.forums.gravityhelp.com/ <p>Hi David,</p> <p>Thank you for the response. I am not trying to change the input type just populate the current type (dropdown) with data in a specific table column. </p> https://legacy.forums.gravityhelp.com/topic/gform_pre_render-help#post-346081 Wed, 26 Jun 2013 13:17:27 +0000 David Peralty 346081@https://legacy.forums.gravityhelp.com/ <p>I don't think anyone is going to give you the database query. But you could use <a href="http://www.gravityhelp.com/documentation/page/Gform_column_input" rel="nofollow">http://www.gravityhelp.com/documentation/page/Gform_column_input</a> to load the values into a drop down field. The example code should get you very close to what you need. </p> https://legacy.forums.gravityhelp.com/topic/gform_pre_render-help#post-346036 Wed, 26 Jun 2013 12:53:58 +0000 gtm1ldy 346036@https://legacy.forums.gravityhelp.com/ <p>Simply trying to populate a drop down from a custom table.</p> <p>Table Name: abc-state-list<br /> Column Name: state_short<br /> Form 1<br /> Field ID 1</p> <p>Can anyone help with the code to make this happen in functions.php? The complete code? </p> <p>Ive read so many submissions and on the web, all reference the help docs but they don't include any help on a sql queries as well.</p> <p>Thank you so much for helping out. It shouldn't be difficult, new to wordpress not to the web. </p>