I have a WP Data Table that I am trying to have one of the columns show as a dropdown menu in Gravity Forms and I am having difficulty doing so.

Can you help me link to some literature to follow or walk me through the process as a Premium member with the Gravity forms add-on. Its a basic license only on one site.

Th table is already linked to my google API and successfully updating.

I've added the following to my functions.php

add_filter( 'gform_pre_render', 'populate_dropdown_field' );
function populate_dropdown_field( $form ) {
    global $wpdb;
    // Change the table name and column name to match your wpDataTable
    $table_name = 'wp_wpdatatable_5';
    $column_name = 'Show Name';
    // Retrieve the values from the specified column in the wpDataTable
    $results = $wpdb->get_results(
        $wpdb->prepare(
            "SELECT DISTINCT %s FROM %s",
            $column_name,
            $table_name
        )
    );
    // Loop through the form fields and find the dropdown field with the parameter name "daily_show_name"
    foreach ( $form['fields'] as &$field ) {
        if ( isset( $field->inputName ) && $field->inputName == 'daily_show_name' ) {
            $choices = array();
            foreach ( $results as $result ) {
                $choices[] = array(
                    'text' => $result->$column_name,
                    'value' => $result->$column_name
                );
            }
            $field->choices = $choices;
            break;
        }
    }
    return $form;
}

I've also purchased the Gravity Wiz Populate Anything plugin which can pull directly from wordpress database.
Type: <sitename>

Table: wp_wpdatatables

Filters:

ID is "5"

and then I have the options to add another filter. (And/Or)

I've selected "And" then looked for where the column data is stored. 

The column that I am looking for is column "2" named "CONTRACTDESCRIPTION".

wpdatatableid=5
column=2
column name= "CONTRACTDESCRIPTION"
displayed header= "myshowname"
data column type= "String"
sorting=allowed
filtering= allowed

I resolved this myself by installing the google sheets add-on to the Gravity Wiz Populate Anything plugin.

It didn't pull from the WPdata table, but since the WPdat table was pulling from google sheets, i was able to do it that way.

(solved)