Table-style questions: Allow calculations across more than one table question
We have a budget form with a table for Revenue and a table for Expenses. It would be great to be able to calculate the net (revenue minus expenses) without the applicant having to do math or cut-paste totals from the separate tables into a third table or field.
Tracy Larimer
shared this idea
-
Renea Muellerleile
commented
I strongly support this idea. I am using Table questions to capture and report on budget information. As Tracy notes, the current functionality creates a signifcant amount of unnecessary work for the applicant/grantee as well as our internal staff - in addition, to the potential for errors that create re-work. Thank you for your consideration!
-
Craig Biehle
commented
We collect data on clients by zip code across 16 counties. We have broken up the zip codes into two forms, one for each state. In each form, we have multiple tables to organize the zip codes by county, making it easier for grantees to identify just the county zip codes they serve. We would LOVE the ability to add up the subtotals from each table on a form to get a grand total.
-
Kathy Westhaver
commented
We would also like to replace our budget form with a table. In addition to the above request to calculate the net, it would be great to allow for sub totals within a table. For example a section to total up scholarships already received.