Hi Allan,

I am trying to use a select menu on editor update and I need to fill the <options> from a database of companies.
I have read the discussion on the forum https://datatables.net/forums/discussion/9899 and have successfully created my function to build an array. However, when I call my function in the editor it doesn't fill my options with anything.

Here's my code for the editor:

 var editor;
        
        editor = new $.fn.dataTable.Editor( {
            edit: {
                type: 'PUT',
                dataSrc: "data.forms",
                url:  apiPathProtected ,
                beforeSend: function (request) {
                    request.setRequestHeader("X-Access-Token", user.token);
                    request.setRequestHeader("Content-Type", "application/json");
                    
                },
                contentType: 'application/json',
                data: function ( d ) {
                    var formData = d.data[Object.keys(d.data)[0]];
                    var customBody = {
                        "data":{ 
                            "id_user": user.userid, 
                            "id_group": user.groupid, 
                            "date_created":formData.date_created, 
                            "company_name":formData.company_name,
                            "first_name": formData.first_name,
                            "last_name": formData.last_name,
                            "form_type": formData.form_type,
                            "key_field_values": formData.key_field_values
                    }
                    }
                    return JSON.stringify(customBody);
                }
            },
            table: "#the-table",
            idSrc:  'id',
            fields: [
                 {
                    "label": "Company:",
                    "name": "company_name",
                    "type":  "select",
                    "placeholder": "Select a Company",
                    "ipOpts": companyNames()
                }
            ] 
        });       

and the ajax function:

function companyNames() {

                $.ajax({
                    url: apiPathProtected ,
                    type: 'GET',
                    dataSrc: "data.companies",
                    beforeSend: function (request) {
                        request.setRequestHeader("X-Access-Token", user.token);
                        request.setRequestHeader("Content-Type", "application/json");
                    },
                    success: function(response) { 
                        if ( response.result == "success"){
                            companyArray = response;
                               
                            if (companyArray.data.companies.length > 0) {                   
                                    
                                for(var z=0; z<companyArray.data.companies.length; z++) {  
                                    var label = "";
                                    var value = "";
                                    
                                    label = companyArray.data.companies[z].company_name;
                                    value = companyArray.data.companies[z].id;

                                    var selectValue = [];
                                    selectValue = [label, value];
                                    
                                }                       
                            }
                                return selectValue;                         
                        } else { 
                            return [];
                        }
                    }
                })
            }

As per the forum discussion I cited I am simply trying to pass the function into the ipOpts and return the array to populate the <option> of my <select> menu.
Any help would be appreciated.