Repeating Subform Set of pages with accumulating total fields. Possible? | Community
Skip to main content
nowackem
nowackem
New Participant
April 13, 2021
Solved

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

  • April 13, 2021
  • 3 replies
  • 1417 views

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by 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.

3 replies

nowackem
nowackemAuthorAccepted solution
New Participant
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.

    kautuk_sahni
    kautuk_sahni
    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
    nowackemAuthor
    New Participant
    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
    nowackemAuthor
    New Participant
    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.
    Terms & ConditionsAccessibility statement

    Loading footer...