Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

JavaScript to Evaluate Value in an Array of Cells

ArrueiraVermelh
Level 3
Level 3

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";

          }

    }

}

0 Replies