How do I add a summary page that displays the totals based on categories from dropdown list?

Avatar

Avatar

jeffm70816839

Avatar

jeffm70816839

jeffm70816839

19-06-2018

How do I add a summary page that displays the totals based on categories from dropdown list? I created a dynamic voucher that can expand to many pages and would like to display a summary page that rolls up the totals for the different expense codes (1-Housing, 2-Medical, 3-Transportation)? So, really two questions how to add a summary page different from the main form, and how to write the java to calculate the totals from the form to populate on the summary page.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

jeffm70816839

Avatar

jeffm70816839

jeffm70816839

26-06-2018

I figured it out, got busy and didn't get back to post. Here is what I came up with

SampleVoucher JS.jpg

Here is the Summary Page where the JS is inserted into each of the total fields and modify the ExpenseCodeValue and the Items.Row(number) and Total(name) for each category

SampleVoucher hierachy.jpg

And here is a shot of the main form where the query runs

SampleVoucher.jpg

Hope this save someone else some time figuring this out.

Answers (3)

Answers (3)

Avatar

Avatar

lateniteNC

Avatar

lateniteNC

lateniteNC

19-06-2018

I did a form that sounds very similar - it has several expandable tables on the first four pages and a summary page on page 5.

Here is a link to that file: https://www.dropbox.com/s/rnkouipscnfvigc/Revised%20NCDOT%20Emergency%20Assistance%20Invoice.pdf?dl=...

Dropbox - Revised NCDOT Emergency Assistance Invoice.pdf

See if that provides some guidance. It is a relatively simple matter to insert some Formcalc code to copy the results from the first several sections and assign that value to the summary table.

Avatar

Avatar

radzmar

MVP

Total Posts

2.6K

Likes

387

Correct Answer

485

Avatar

radzmar

MVP

Total Posts

2.6K

Likes

387

Correct Answer

485
radzmar
MVP

25-06-2018

The solution in this thread is what you're looking for.

expanding table sumif inside an expanding table

Avatar

Avatar

jeffm70816839

Avatar

jeffm70816839

jeffm70816839

19-06-2018

That helped answer adding the summary page, the second part I believe will require java because I only have one expanding table that has a column with expense code categories that I need to "filter" totals for each of the codes. Can Formcalc query Thanks for the help.