https://legacy.forums.gravityhelp.com/topic/enum-values Gravity Support Forums Topic: enum values en-US Thu, 23 Apr 2026 00:19:53 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/enum-values#post-60643 Tue, 29 May 2012 12:09:47 +0000 Carl Hancock 60643@https://legacy.forums.gravityhelp.com/ <p>If you would like to dynamically populate a drop down field on your form using values from a custom database or custom tables, you can do so by dynamically populating the field using available hooks and custom PHP. </p> <p>This would only allow you to populate the drop down options, the form is still going to store it's data in the Gravity Forms entry tables unless you customize it further to behave otherwise.</p> <p>Here is information on how to dynamically populate a drop down using PHP:</p> <p><a href="http://www.gravityhelp.com/documentation/page/Dynamically_Populating_Drop_Down_Fields" rel="nofollow">http://www.gravityhelp.com/documentation/page/Dynamically_Populating_Drop_Down_Fields</a> </p> https://legacy.forums.gravityhelp.com/topic/enum-values#post-60606 Tue, 29 May 2012 09:07:48 +0000 strmiba 60606@https://legacy.forums.gravityhelp.com/ <p>I'm locking for a plugin that can handle my custom table with enum-fields in. I would like to have a form that builds a drop-down list from the enum values that already excist in the table.</p> <p>Like this php:</p> <p>$result = mysql_query("SELECT COLUMN_TYPE FROM INFORMATION_SCHEMA.COLUMNS<br /> WHERE TABLE_NAME = '$table_name' AND COLUMN_NAME = '$column_name'")<br /> or die (mysql_error());<br /> $row = mysql_fetch_array($result);<br /> $enumList = explode(",", str_replace("'", "", substr($row['COLUMN_TYPE'], 5, (strlen($row['COLUMN_TYPE'])-6))));<br /> foreach($enumList as $value)<br /> echo "[option value=$value]$value[/option]";<br /> echo "[/select]";</p> <p>All the best,</p> <p>Mikael </p> https://legacy.forums.gravityhelp.com/topic/enum-values#post-60603 Tue, 29 May 2012 08:58:00 +0000 David Peralty 60603@https://legacy.forums.gravityhelp.com/ <p>Can you explain more about what you are trying to do, please? </p> https://legacy.forums.gravityhelp.com/topic/enum-values#post-60589 Tue, 29 May 2012 03:54:44 +0000 strmiba 60589@https://legacy.forums.gravityhelp.com/ <p>May I use enum values from a custom table in forms made with Gravity Forms? </p>