[Solved] Batch Editing Grid Cumulative Column

[Satya]

I have Telerik MVC Batch Editing Grid (Client Editable Mode), with three columns  "Start Date", "Planned Days", "Target completion date".  User can change "planned days", by changing "planned days" Target Completion Date needs to be recalculated and at the same time subsequent below rows start date needs to be re calculated based on above row target completion date.

Thanks in Advance

[Petur Subev]

Hello Satya,

I am afraid that creating dependency fields/columns is not supported by the MVC Grid.  The only way to enable behavior similar to the one you covered would be to traverse the Grid table manually with jQuery and update the need elements. You will also need to update the underlying dataItem aswell with the help of the dataItem method(changing only the HTML wont make any changes to the server).

I would suggest you to use Kendo Grid which dataSource objects and observable items could be easily updated. Also you can use create calculated field to handle this.

Kind Regards,
Petur Subev
the Telerik team