How Oracle APEX

by: Amr Abdeen

Oracle APEX | Calculate Tabular Form [Rows & Columns] by JS

by · Published · Updated

Calculate Tabular Form [Rows & Columns] by JavaScript

Please follow next steps..

  1. Copy this code and paste it into Page >> Function and Global Variable Declaration

    // Get sum Rows
function getSumRows(){
    $('input[name="f06"]').each(function () {
        var rowId       = this.id.substr(4);
        var salVal      = $('#f04_'+rowId).val();                                   // Sal Value
        var taxVal      = $('#f05_'+rowId).val();                                   // Tax Value
        var commVal     = $('#P2_COMMISSION').val();                                // Commission Value
        var calc        = Number(salVal) + Number(taxVal) + Number(commVal);        // Calculation

        // Set Value
        $('#f06_'+rowId).val(calc);
 }); 
    
    // Every Calculate will be check values and set Total ...
    getTotalNetColumn();
}

// Get Total of Net Column
function getTotalNetColumn() {
    var clmn=new Array();
    var tol_net=0;
    clmn=document.getElementsByName("f06");

    for(i=0;i<clmn.length;i++)
    {
        tol_net = (tol_net*1) + (clmn[i].value.replace(/,/g, '') * 1);
    }

    // Set Total Value
    $('#P2_TOTAL').val(Number(tol_net));
}

     

  2. Copy this code and paste it into Page >> Execute when Page Loads

    // Get Sum Rows of tabular
getSumRows();

     

  3. Watch next Clip
    [embedyt] https://www.youtube.com/watch?v=eHWtpukGyUE[/embedyt]
  4. Sample Application  Download

 

Regards,

Amr

You may also like...