Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Validate 1
Level 1
jeffm70816839
Level 1

Likes

0 likes

Total Posts

6 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
jeffm70816839
Level 1

Likes

0 likes

Total Posts

6 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Affirm 1
View profile
jeffm70816839
Level 1

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
Validate 1
Level 1
jeffm70816839
Level 1

Likes

0 likes

Total Posts

6 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
jeffm70816839
Level 1

Likes

0 likes

Total Posts

6 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Affirm 1
View profile
jeffm70816839
Level 1

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
Validate 1
Level 3
lateniteNC
Level 3

Likes

12 likes

Total Posts

98 posts

Correct Reply

13 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 3
lateniteNC
Level 3

Likes

12 likes

Total Posts

98 posts

Correct Reply

13 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
lateniteNC
Level 3

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
Coach
MVP
radzmar
MVP

Likes

395 likes

Total Posts

2,686 posts

Correct Reply

491 solutions
Top badges earned
Coach
Ignite 3
Ignite 1
Validate 1
Give Back 50
View profile

Avatar
Coach
MVP
radzmar
MVP

Likes

395 likes

Total Posts

2,686 posts

Correct Reply

491 solutions
Top badges earned
Coach
Ignite 3
Ignite 1
Validate 1
Give Back 50
View profile
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
Validate 1
Level 1
jeffm70816839
Level 1

Likes

0 likes

Total Posts

6 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
jeffm70816839
Level 1

Likes

0 likes

Total Posts

6 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Affirm 1
View profile
jeffm70816839
Level 1

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.