Set value of another cell based on selected item from Combo box

[Jason]

I have a Grid defined as:

$("#FloorPlanGrid").kendoGrid({
        dataSource: floorPlanSource,
        toolbar: ['create'],
        columns: [
            {field: 'CompanyName', title: 'Company Name', editor: flooringDropDown},
            {field: 'AccountNumber', title: 'Account Number'},
            {field: 'CompanySubType', title: 'Sub Type'},
            {field: 'Active', title: 'Active'},
            {field: 'CreditAvailable', title: 'Credit Available'},
            {field: 'DFINumber', title: 'DFI Number'},
            {field: 'ClosedDate', title: 'Closed Date'},
            { command: ['edit', 'destroy'] }
        ],
        editable: 'inline',
        //edit: function (e) {
        //  debugger;
        //}
    });

With a custom editor for the company name defined as:

function flooringDropDown(container, options) {
    $("<input required data-text-field='Text' data-value-field='Value' data-bind='value: " + options.field + "'/>")
        .appendTo(container)
        .kendoDropDownList({
            autoBind: false,
            dataSource: {
                transport: {
                    read: window.PaymentOutsideOptionsUrl
                }
            },
            select: function(e) {
                var item = this.dataItem(e.item.index());

                if (item) {
                    console.log(item.SubType);
                    debugger;
                }
            }
        }
    );
}

Where the debugger line is in the select event, I would like to set the value of the CompanySubType to item.SubType. I have verified that I can get the SubType, but I cannot for the life of me figure out how to set the value of the CompanySubType column. Could someone demonstrate how to set this value?

Jason

[Dimiter Madjarov]

Hi Jason,


I would suggest you to get the model for the current item through the options.model parameter and then use it's set method to update the value of CompanySubType.

E.g.

function flooringDropDown(container, options) {
    //get the current model
    var model = options.model;
    $("<input required data-text-field='Text' data-value-field='Value' data-bind='value: " + options.field + "'/>")
            ...
            select: function(e) {
                var item = this.dataItem(e.item.index());

                if (item) {
                    //update the value
                    model.set("CompanySubType", item.SubType);
                }
            }
        }
    );
}

I hope this information was useful for you. 

Kind regards,
Dimiter Madjarov
the Telerik team