Want to add Total for each column in table footer

Forms SharePoint 2019
1

I am building simple form , where I have a table and want to add sum in last row. Last row must not be editable manually.

image
image1055×268 8.55 KB 

fd.spRendered(function () {
var dt = $(fd.control('DataTable1').$el);

//hides 'Add new record' button  
dt.find('.fd-datatable div.k-header.k-grid-toolbar').css('display', 'none')
//hides delete column
dt.find('.fd-datatable table tr th:first-child,.fd-datatable table tr td:first-child').css('display', 'none');


     var dt_rows = [];
    var row1 = {Column1: "item 01", Column2: "0",Column3:"0"};
    dt_rows.push(row1);
     var row2 = {Column1: "item 02", Column2: "0",Column3:"0"};
    dt_rows.push(row2);
 var row3 = {Column1: "item 03", Column2: "0",Column3:"0"};;
    dt_rows.push(row3);
     var row3 = {Column1: "Total", Column2: "0",Column3:"0"};;
    dt_rows.push(row3);
    fd.control('DataTable1').value = dt_rows;

    fd.control('DataTable1').$on('change', function(value){
            var totalDataTable = 0;
            debugger
            console.log(value)
            value.forEach(function(line){

                if(line.Column1){
                    totalDataTable = parseFloat(line.Column2)+totalDataTable;
                }

            });
           // fd.field('Number1').value = totalDataTable;
        });
});```
2

Hello @sanaullah102,

We can offer paid support to add the ability to disable the last row and display totals for each column in it. Please email us at support@plumsail.com.

An alternative would be to calculate the total and show the result in separate fields. Please find an example here.