https://legacy.forums.gravityhelp.com/topic/drop-down-dynamic-population-from-single-line-text Gravity Support Forums Topic: Drop down dynamic population from single line text en-US Mon, 20 Apr 2026 10:10:52 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/drop-down-dynamic-population-from-single-line-text#post-44928 Sun, 25 Dec 2011 19:11:34 +0000 kyle 44928@https://legacy.forums.gravityhelp.com/ <p>I was intrigued by this one, so I took a stab at it. Stealing a bit from <a href="http://www.gravityhelp.com/forums/topic/counting-responses#post-43591" rel="nofollow">here</a> and <a href="http://www.gravityhelp.com/documentation/page/Dynamically_Populating_Drop_Down_Fields" rel="nofollow">here</a> I came up with the following.</p> <p>First.. create your dropdown field. Set the single option text to "Add New City" and the value to '' (blank). Click Advanced, and give it a class of "populate-city".</p> <p>Add a second field below that. GIve it a title of New City. Make a note of the field ID. Set the Conditional tag to only show if your dropdown is set to ADD NEW CITY.</p> <p>Then, in your functions.php file, add the following:</p> <pre><code>&lt;?php // update the &#39;2&#39; in gform_pre_render_2 to the ID of your form add_filter(&#39;gform_pre_render_2&#39;, &#39;populate_cities&#39;); function populate_cities($form){ foreach($form[&#39;fields&#39;] as &amp;$field){ if($field[&#39;type&#39;] != &#39;select&#39; || strpos($field[&#39;cssClass&#39;], &#39;populate-city&#39;) === false) continue; // get previous entries user-added cities // update the 4 below to the field ID of your &quot;New City&quot; field $cities = get_entry_field_values(4, $form[&#39;id&#39;]); // update &#39;City Dropdown $choices = array(); foreach($cities as $city){ $choices[] = array(&#39;text&#39; =&gt; $city[&#39;value&#39;], &#39;value&#39; =&gt; $city[&#39;value&#39;]); } $choices[] = array(&#39;text&#39; =&gt; &#39;Add New City&#39;, &#39;value&#39; =&gt; &#39;&#39;); $field[&#39;choices&#39;] = $choices; } return $form; } function get_entry_field_values($field_id, $form_id) { global $wpdb; $tablename = $wpdb-&gt;prefix . &#39;rg_lead_detail&#39;; return $wpdb-&gt;get_results($wpdb-&gt;prepare(&quot;SELECT value FROM $tablename WHERE form_id = %d AND field_number = %d&quot;, $form_id, $field_id), ARRAY_A); } ?&gt;</code></pre> <p>You may want to sort the choices array, and check for duplicates, not to mention make sure the formatting [capitalization, etc.] is correct, but I'll leave that up to you. When someone goes to fill out the form, they'll see a list of previously added cities. They can choose that or choose "ADD NEW CITY" and use the input field that appears to enter their city name. </p> <p>Hope it helps. </p> https://legacy.forums.gravityhelp.com/topic/drop-down-dynamic-population-from-single-line-text#post-44922 Sun, 25 Dec 2011 03:14:26 +0000 MiikkaMakio 44922@https://legacy.forums.gravityhelp.com/ <p>Anyone?</p> <p>I've made couple changes to the names of the fields.. I know this is not too difficult thing but can't get it working!</p> <p>What would I need to add to get the dynamic population to work for the 'Kaupunki' drop down?<br /> If the Kaupunki that the form user wants to select is not ready in the drop down list, he would be able to write to the 'Kaupunki jos ei listalla' and next user of the form would see that one in the 'Kaupunki' drop down.<br /> I tried to follow the guide and read bunch of topics many times, but didn't quite get how I should determine that it takes the text from the 'Kaupunki jos ei listalla' etc. </p> https://legacy.forums.gravityhelp.com/topic/drop-down-dynamic-population-from-single-line-text#post-43993 Wed, 14 Dec 2011 01:55:36 +0000 MiikkaMakio 43993@https://legacy.forums.gravityhelp.com/ <p>Hey,</p> <p>I've been struggling with the dynamic population thing for some time. Trying to populate a drop down from a single line text -field.</p> <p>What would I need to add to get the dynamic population to work for the 'City' drop down?<br /> If the City that the form user wants to select is not ready in the drop down list, he would be able to write to the 'City if not in the list' and next user of the form would see that one in the 'City' drop down.<br /> I tried to follow the guide and read bunch of topics many times, but didn't quite get how I should determine that it takes the text from the 'CIty if not in the list' etc.</p> <p>FORM: <a href="http://www.vaihtoon.fi/WordPress/share" rel="nofollow">http://www.vaihtoon.fi/WordPress/share</a></p> <p>Help needed, thanks!</p> <p>-Miikka </p>