JavaScript to Evaluate Value in an Array of Cells

ArrueiraVermelh

09-02-2018

Hi There,

I am working on a pricing table in an ordering form. I need to show a subform if any row has a subtotal above 2,000. I was able to get that script going except that when the "add row" is clicked the subform is hidden again no matter which subtotals values I have in that column. Another issue is that when edits are made to quantity and unit price the subtotal is not updating. The " delete row"  option doesn't seem to affect the script negatively. How can I get "Add row"  to correctly evaluate if any subtotal cell in the table is above or below 2,000 and show/hide the subform accordingly. And why is my calculation no updating when I change  actual and qty values?

Thanks in advance for any help!

Here is what I have:

Script in Calculate event of the subtotal (extended) cell:

if ( actual.rawValue != null || qty.rawValue != null) {

this.rawValue = actual.rawValue * qty.rawValue;

}

checkValues.compAnalysis()

Function:

function compAnalysis() {

var oFields = xfa.resolveNodes("PRForm.orderDetails.orderTable.orderLine[*].extended[*]");

var nNodesLength = oFields.length;

for (var nNodeCount = 0; nNodeCount < nNodesLength; nNodeCount++) {    

nLineTotal = oFields.item(nNodeCount).rawValue;

if ( nLineTotal != null && nLineTotal >= 2000 ) {

      this.resolveNode("H-comparativeBids").presence = "visible";

      this.resolveNode("H-comparativeBids.justification").validate.nullTest = "error";

      }

    else if ( nLineTotal == null || nLineTotal <= 2000 ) {

          this.resolveNode("H-comparativeBids").presence = "hidden";

          this.resolveNode("H-comparativeBids.justification").validate.nullTest = "disabled";

          }

    }

}

Accepted Solutions (0)

Answers (0)