Skip to main content
nowackem
nowackem
Level 5
April 13, 2021
해결됨

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

  • April 13, 2021
  • 6 답변들
  • 1459 조회

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!

이 주제는 답변이 닫혔습니다.
최고의 답변: nowackem

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.

6 답변

nowackem
nowackem작성자
Level 5
April 20, 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.
kautuk_sahni
Adobe Employee
kautuk_sahniAdobe Employee
Adobe Employee
April 22, 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.

Kautuk Sahni
nowackem
nowackem작성자
Level 5
April 22, 2021
@kautuk_sahni I'm kinda new here and this is the first time I've answered a question (even though it was my own, Ha!). How do I share the answer with the community?
nowackem
nowackem작성자답변
Level 5
April 22, 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.

    약관 및 조건Accessibility statement

    Loading footer...