Simply trying to populate a drop down from a custom table.
Table Name: abc-state-list
Column Name: state_short
Form 1
Field ID 1
Can anyone help with the code to make this happen in functions.php? The complete code?
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.
Thank you so much for helping out. It shouldn't be difficult, new to wordpress not to the web.
I don't think anyone is going to give you the database query. But you could use http://www.gravityhelp.com/documentation/page/Gform_column_input to load the values into a drop down field. The example code should get you very close to what you need.
Sorry, wrong documentation page. http://www.gravityhelp.com/documentation/page/Gform_field_choices Is what you require.
Hello,
This documentation is for checkbox selections. Below is my code, it will not return the States from the table. Help would be greatly appreciated?
add_filter("gform_pre_render_5", populate_dropdown);
add_filter("gform_admin_pre_render", populate_dropdown);
function populate_dropdown($form){
global $wpdb;
if($form["id"] != 5)
return $form;
$mytable = $wpdb->btc_state_list;
$q = "SELECT btc_state_short from $mytable";
$results = $wpdb->get_results($q);
$items = array();
$items[] = array("text" => "", "value" => "");
foreach ($results as $result) {
$items[] = array("value" => $results->state, "text" => $results->state);
}
foreach($form["fields"] as &$field){
if($form ["id"] == 1){
$field["choices"] = $items;
}
}
return $form;
}
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?
OK. I have it narrowed down, I can manuall add choices but cannot retreive table data. Here is where I am at.
add_filter("gform_pre_render_5", populate_dropdown);
add_filter("gform_admin_pre_render_5", populate_dropdown);
function populate_dropdown($form){
global $wpdb;
$results = $wpdb->get_row("SELECT btc_state_short from btc_state_list");
$choices = array();
$choices[] = array("text" => "2323", "value" => "2323");
// This is where I am stuck
foreach ($results as $result) {
$choices[] = array("value" => $result->value, "text" => $result->value);
}
foreach($form["fields"] as &$field){
if($field["id"] == 1){
$field["choices"] = $choices;
}
}
return $form;
}
