Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.
SOLVED

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

Avatar

Level 2

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.

1 Accepted Solution

Avatar

Correct answer by
Level 2

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.

View solution in original post

4 Replies

Avatar

Level 4

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

Level 2

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.

Avatar

Correct answer by
Level 2

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.