Gravity Support Forums Topic: Drop Down List / No duplicates

Gravity Support Forums Topic: Drop Down List / No duplicates https://legacy.forums.gravityhelp.com/topic/drop-down-list-no-duplicates Gravity Support Forums Topic: Drop Down List / No duplicates en-US Sat, 18 Apr 2026 11:13:13 +0000 http://bbpress.org/?v=1.0.1 <![CDATA[Search]]> q https://legacy.forums.gravityhelp.com/search.php Chris Hajer on "Drop Down List / No duplicates" https://legacy.forums.gravityhelp.com/topic/drop-down-list-no-duplicates#post-168442 Tue, 12 Mar 2013 01:31:07 +0000 Chris Hajer 168442@https://legacy.forums.gravityhelp.com/ One of our developers has a solution over at Gravity Wiz for this called "GP Limit Choices". You can read about it here: <a href="http://gravitywiz.com/gravity-perks/" rel="nofollow">http://gravitywiz.com/gravity-perks/</a> I don't know of a way to do it with gform_pre_render. ateam981 on "Drop Down List / No duplicates" https://legacy.forums.gravityhelp.com/topic/drop-down-list-no-duplicates#post-163670 Thu, 07 Mar 2013 18:44:23 +0000 ateam981 163670@https://legacy.forums.gravityhelp.com/ <a href="http://rotaryribfest.muldowneyarts.net/purchase-a-booth-for-2013-event/" rel="nofollow">http://rotaryribfest.muldowneyarts.net/purchase-a-booth-for-2013-event/</a> functions.php: <pre><code><?php // current url function function current_url() { $pageURL = 'http'; if ($_SERVER["HTTPS"] == "on") {$pageURL .= "s";} $pageURL .= "://"; if ($_SERVER["SERVER_PORT"] != "80") { $pageURL .= $_SERVER["SERVER_NAME"].":".$_SERVER["SERVER_PORT"].$_SERVER["REQUEST_URI"]; } else { $pageURL .= $_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"]; } return $pageURL; } //cull out booths already reserved add_filter("gform_pre_render", "populate_dropdown"); //add_filter("gform_admin_pre_render", "populate_dropdown"); function populate_dropdown($form){ global $wpdb; if($form["id"] != 2) return $form; $posts = $wpdb->get_results("SELECT boothname FROM $wpdb->booth"); $items = array(); $items[] = array("text" => "Select a slot", "value" => ""); foreach($posts as $post) $items[] = array("text" => $post->boothname, "value" => $post->boothname); foreach($form["fields"] as &$field) if($field["id"] == 7){ $field["choices"] = $items; } return $form; }</code></pre> ateam981 on "Drop Down List / No duplicates" https://legacy.forums.gravityhelp.com/topic/drop-down-list-no-duplicates#post-162274 Wed, 06 Mar 2013 18:15:36 +0000 ateam981 162274@https://legacy.forums.gravityhelp.com/ How do I configure the drop down field type to not show selections for items that have already been chosen from the list (no duplicates stops the add of record, but it would be nice to not show the ones on file. I have reviewed and searched for 2 days on how i might do this in php with prerender, but all of the examples use simple calls to getposts. My guess is that the combination of not fully understanding the db structure form my gforms tables and how to organize the php to do what i need is the culprit. Any help would be great. Thanks in advance.