Hello,
I want to put in some lines of code in a template (word doc) to get the total amount of fields when generating a report from a survey that I published. I created a survey in which users can assess the conditions of households and properties after a natural disaster. These conditions are reported as waypoints. One group of waypoints refers to the level of damage of a property if any (i.e. affected - minor damage, completely destroyed, unaffected, etc.). Another group of waypoints refers to human activity in the area of interest, so in addition to the total amount of each type of waypoint, I also want to calculate the total amount of people reported under each kind of waypoint.
The template (word doc) that I created when generating reports has columns for the total amount of each type of waypoint. In each of these cells, I want to put a line of code that will give me the sum of each type of waypoint. For example, if there are 5 inputs that reported a "Shelter in place" waypoint and each house has 3 people associated with it I want to be able to generate a report that shows 5 for total waypoint count and 15 for total person count in the "Shelter in place" waypoint category.
Attached is a picture of the survey word doc showing where the totals would need to be for each waypoint category. I circled examples of the locations where the code to sum the # of waypoints and the # people would be.
Any help would be appreciated! Thanks!