[ptmi1047]

Hi,

I have a grid with delete row button, and a text field to show total amount from a column in grid.
I do not use grid summary because I need to show the amount with currency format in the field.
How to make the value in text field calculate automatically once I click delete button in grid?


Thank you.

[mishika]

Hello ,

You can use the JS function onDeleteRow() for grids in order to calculate the sum whenever the row is deleted. Please have a look at the function below:

Code: Select all

$("#gridId").onDeleteRow(function(oGrid, aRow, rowIndex) {
   //code for calculation goes here
  var val = parseInt(aRow[0][4].getValue()); //value of deleted row
  var total = parseInt($('#total').getValue()); //get the value of total and subtract the value of deleted row from it
  var sum = total - val;
  $('#total').setValue(sum);
});

Kindly refer to this documentation for more details:
http://wiki.processmaker.com/3.1/JavaSc ... nDeleteRow

You can change the code according to your requirement.

Hope this helps

Best Regards
Mishika

[ptmi1047]

Hi Mishika,

Thanks for your solution.
I modified the code since the value in grid using currency format.

Code: Select all

$("#OtherExpenses").onDeleteRow(function(oGrid, aRow, rowIndex) {
        
    var Total = 0;
    var Amount = parseFloat(toAngka($('#TotOthExp').getValue())); 
    
    var a1 = aRow[0][4].getValue(); 
    var a2 = a1.replace(",",""); 
    var a = parseInt(a2.replace(",",""));  
    
    var PPN = $('#PPN').getValue();
    
    if (PPN == "0"){
        var TotalOth = Amount - a;
    }
    else {

        var TotalOth = Amount - (a + ((a * 10)/100));

    }
    
    var Summ = toCurr(TotalOth,"");
    
  	 if (isNaN(TotalOth)) { 
      	TotalOth = '';
   	}
   	else { 
      	$('#TotOthExp').setValue(Summ);
    }

  });