Calculating the total of dynamic subforms using javascript

[UTEntertainment]

I have created a dynamic form that allows me to add or subtract the amount of entries using the instance manager. I can calculate a total for each instance, but how do I get the total of each one of those instances using Javascript?

[UTEntertainment]

I think I know a way to do it with tables but that is with formcalc. I can try that but I wanted to keep it with subforms and use javascript if possible. Anyone have any Ideas?

[Niall_O_Donovan]

Hi,

I have an example here:

http://www.assuredynamics.com/index.php/category/portfolio/building-dynamic-tables/

Its main purpose is to show how to build dynamic tables, but if you have a look at the total field you will see the FormCalc script. To be honest it is much easier to do this using FormCalc because with this language you do not need to resolve each instance.

// sum using FormCalc
$ = Sum(Row1[*].amount)

You can do this in Javascript, but it is a slightly longer script.

// sum using Javascript 
var vTotal = 0; 
var vRows = _Row1.count; 
for (var i=0; i<vRows; i++)
{
     vTotal = vTotal + xfa.resolveNode("Row1[" + i + "]").amount.rawValue; 
}
this.rawValue = vTotal;

Both will achieve the same thing and will be automatically updated as rows are added and deleted, but overall the FormCalc is a simpler script.

Hope that helps,

Niall

Assure Dynamics

[UTEntertainment]

I was trying to do it without a table, but I ended up converting it to a table so the code you gave me works with that. Thanks.

[Niall_O_Donovan]

Aghh, that's a pity.

The building dynamic tables example (http://assure.ly/gBJYj9) had a repeating subform example (Table 6). The FormCalc is very similar, you just reference the repeating subform.

// sum using FormCalc
$ = Sum(rowSubform[*].amount)

Good luck,

Niall

Assure Dynamics