Expand my Community achievements bar.

Can't get totals to sum across several pages

Avatar

Level 1

Been struggling for ages to try and solve a nested subform calculation problem and flowing the totals across several pages to give a final total at the end. The form adds individual lines to a section and also adds new sections so it's not straightforward,

I've been trying various ways of using the 'var fields = xfa.layout.pageContent(0,"fields") which calculates the sum of the first page fine, but I can't get the Total Sum to carry forward to subsequent pages. I've tried various scripts that replace with '0' with page number type script but I've not found one that works.

I'm a real newbie at this and have used sample scripts to compile a customer ordering form for use on line but am stuck at this last bit.

Also, when a section flows onto a new page I'm getting a complete subform and not a continuing part of the subform (more an irritant than a technical problem at this stage)

I've uploaded my form to my website here http://www.actiontrophies.co.uk/footballorder.pdf and set the form up to add 3 lines for trial purposes.

Any help from you experts out there will be much appreciated. Thanks

1 Reply

Avatar

Level 2

I would probably use numeric fields in a table rather stand alone fields.

FormCalc is a little more effcient than javascript with this sort of thing. I've used this method:

if (HasValue(ExpenseClaim.Page1.MiscExpenses.TableExpense.Row1.Cell6)

$.rawValue = Sum(TableExpense.Row1[*].Cell6);

else

$.rawValue = null

endif