Programmatically set value to treelist cell

[Josetuttu]

How can I set value programmatically to a cell in Treelist from javascript after the data is loaded?

Say I have quantity and price, I need to update the total amount column when I change value quantity or price.

[Nikolay]

Hello Josetuttu,

In the given scenario it is best to display the total amount column with a template where its value is the quality multiplied by the price. This way once the price or the quantity is updated the total amount will automatically update as well.

template: "#= data.Price*data.Quantity #"

Another option to update a model property is using the set() method.

Let me know if this is what you are looking for.

Regards,
Nikolay
Progress Telerik

[Josetuttu]

Thanks Nikolay. I was trying the set method itself. But the set method is expecting 3 parameters and I couldn't find any documentation or example regarding that. 
The problem I faced was that the column I was trying to set was marked as editable false in the schema since it is a calculated field. This was preventing setting the value to the field. I assume this is not a desirable behavior as making it editable will allow user to change value of a calculated field. Nonetheless, I made it editable in the schema and close the cell when user tries to edit it.

[Nikolay]

Hi Josetuttu,

Thank you for following up.

Closing the cell the user tries to edit is a valid solution. You can also use the columns.editable configuration and set the function no return false.

• https://docs.telerik.com/kendo-ui/api/javascript/ui/grid/configuration/columns.editable

The set() method actually expects two parameters: the model property and the new value for it. Am I missing something?

Regards,

Nikolay

[Josetuttu]

Dear Nikolay,

Please find below the screenshot of set function expecting 3 parameters. This is taken from inspection window and treelist demo.

 

Regards

Jose Tuttu George

[Nikolay]

Hi Josetuttu,

Here is the internal implementation of the set() method expecting only two parameters - field and value:

 set: function(field, value) {
            var that = this,
                isSetPrevented = false,
                composite = field.indexOf(".") >= 0,
                current = kendo.getter(field, true)(that);

            if (current !== value) {
                if (current instanceof Observable && this._handlers[field]) {
                    if (this._handlers[field].get) {
                       current.unbind(GET, this._handlers[field].get);
                    }
                    current.unbind(CHANGE, this._handlers[field].change);
                }

                isSetPrevented = that.trigger("set", { field: field, value: value });

                if (!isSetPrevented) {
                    if (!composite) {
                        value = that.wrap(value, field, function() { return that; });
                    }
                    if (!that._set(field, value) || field.indexOf("(") >= 0 || field.indexOf("[") >= 0) {
                        that.trigger(CHANGE, { field: field });
                    }
                }
            }

            return isSetPrevented;
        },

Regards,

Nikolay