Update column value based on other column values in ASP.NET MVC Grid

[luis]

How to set one cell value based on the other cell value in grid JS2 MVC or JS2?

[Pavithra Subramaniyam]

Hi Luis, 

 

Thanks for contacting Syncfusion support. 

 

We have analyzed your requirement. We suspect that you would like to update a column value(for example “Total” column) based on other column values while performing editing in Grid. We have achieved this requirement by using the “ActionBegin” event of Grid. In the “ActionBegin” handler, based on the “requestType” as “save”, we have updated the “args.data.Total” value. Please refer the cod example below, 

 

 

<div> 

    @Html.EJS().Grid("Grid")...ActionBegin("ActionBegin")...Render() 

</div> 

 

<script type="text/javascript"> 

    function ActionBegin(args) { 

        if (args.requestType == "save") { 

            args.data.Total = document.getElementsByName("OrderID")[0].value * document.getElementsByName("EmployeeID")[0].value;  //Update "Total" column based on OrderID and EmployeeID values 

        } 

    } 

</script> 

 

Documentation : https://ej2.syncfusion.com/javascript/documentation/api/grid#actionbegin 

 

We are also attaching the sample for your convenience, please download the sample from the link below, 

Sample : http://www.syncfusion.com/downloads/support/directtrac/general/ze/gridmvclocalization-289820054 

 

Please get back to us if you need further assistance. 

 

Regards, 

Pavithra S.