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

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)

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)

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.

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.