Repeating Subform Set of pages with accumulating total fields. Possible?

Avatar

Avatar
Boost 3
Level 2
nowackem
Level 2

Likes

4 likes

Total Posts

45 posts

Correct reply

2 solutions
Top badges earned
Boost 3
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Boost 3
Level 2
nowackem
Level 2

Likes

4 likes

Total Posts

45 posts

Correct reply

2 solutions
Top badges earned
Boost 3
Validate 1
Boost 1
Affirm 1
View profile
nowackem
Level 2

13-04-2021

UPDATE: I have figured out how to repeat the pages infinitely and get grand totals to appear, however I wanted the totals to actually accumulate every time a subform set is added and not have the entire form grand totals from page one on. Does that make sense? I have replaced the document with the updated one incase anyone is able to take a minute to help me figure this out.

A link to the updated file:

https://drive.google.com/drive/folders/1PgZNO6ljXEXHSjK4ksl94Bmj6L4WIqIs?usp=sharing

__________

Is there a way to script accumulating totals in tables that are located on a 2+ page (I say 2+ because there is a table on page 2 that has a repeating row) form that has been placed into a Subform Set so the user can add an instance of these two repeating pages an infinite amount of times? The trick is that I need to make accumulating totals in some of these fields as the user repeats the Subform Set of pages and fills out certain fields.

 

Thank you!

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 3
Level 2
nowackem
Level 2

Likes

4 likes

Total Posts

45 posts

Correct reply

2 solutions
Top badges earned
Boost 3
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Boost 3
Level 2
nowackem
Level 2

Likes

4 likes

Total Posts

45 posts

Correct reply

2 solutions
Top badges earned
Boost 3
Validate 1
Boost 1
Affirm 1
View profile
nowackem
Level 2

22-04-2021

I figured this out for anyone who needs this. The code for the accumulating total box needed a [*] after each section of the field address. Here is the code: sum(Page1[*].subPart1[*].tblPart1[*].Row5[*].PageTot[*]) Now as I add an instance of my Subform Set, the totals now accumulate.

Answers (1)

Answers (1)

Avatar

Avatar
Establish
Community Manager
kautuk_sahni
Community Manager

Likes

1,200 likes

Total Posts

6,394 posts

Correct reply

1,147 solutions
Top badges earned
Establish
Coach
Originator
Contributor 2
Contributor
View profile

Avatar
Establish
Community Manager
kautuk_sahni
Community Manager

Likes

1,200 likes

Total Posts

6,394 posts

Correct reply

1,147 solutions
Top badges earned
Establish
Coach
Originator
Contributor 2
Contributor
View profile
kautuk_sahni
Community Manager

22-04-2021

@nowackem share the answer with community.

 

//I figured this out for anyone who needs this. The code for the accumulating total box needed a [*] after each section of the field address. Here is the code: sum(Page1[*].subPart1[*].tblPart1[*].Row5[*].PageTot[*]) Now as I add an instance of my Subform Set, the totals now accumulate.