[Solved] Can I set the value of a grid cell during an onSave event?

[Christopher Ronak]

Hi,

I have a grid which I've declared using inCell editing
        .Editable(editing => editing.Mode(GridEditMode.InCell))

When the user modifies one value in the grid, I'd like to catch that event and use that value to update another item in the grid - and have that show up on the grid. I don't actually want to save any of these values to the server until the user hits submitChanges() - so the save gets interrupted using a preventDefault().

In my sample function below, I calculate a billable value using the Markup entered by the user. But how do I then get that billable value to show up in the grid cell?

function InvoiceCommitmentsGrid_onSave(e) {
        var values = e.values;
        var markup = parseFloat(values.Markup) / 100;
        var cost = parseFloat(values.InvoiceCostAmount);
        var billable = cost + (cost * markup);
        var dataItem = e.dataItem;
        dataItem.InvoiceBillableAmount = billable;
        e.preventDefault();
    }

Thanks for any help!

Chris

[Petur Subev]

Hello,

Generally speaking you do not need to call the e.preventDefault()method because by default there will not be any request executed until the submit changes is not triggered.
You can use the saveCell method (which accepts a td element) exposed by the Grid object to update the content of the cell which you want to update (your target cell does not need to be in edit mode).
Or you can manually update the content of the cell like shown in the attached project (check the ClientSide.cshtml).
I hope this helps.

All the best,
Petur Subev
the Telerik team

[Francisco]

Please Help!
I am in the same situation! How to update a cell before manually?

[Swa]

Thnx the post was really helpful