How to Build Form that Breaks Down Info By Community

ScottCratty

Help! I want to build a form where the first question is "Choose which community you live in" and then there will be about 10 questions after that about tracking different types of volunteer hours.

I then want to be able to look at and export the incoming answers and analyze the data based on each community. So, for example, after 1,000 people fill out the survey I want to look at the data and see all the answers for people that selected San Francisco and then all the answers for people that selected Los Angeles and then all the answers for people that selected Santa Barbara, etc. 

Thanks in advance for any help!! 

DavidSolari

If the subsequent questions are identical then a select_one communities with a matching choice list is all you need. Each survey feature will have that community logged so you can aggregate and pivot easily.

If there's differences in the questions based on the community, then things get tricky. If it's the same field set but different choices/constraints/etc. then you can use tools like cascading selects or conditional statements in constraints (e.g. . < if(${community} = 'San Francisco', 80, 40)). If the fields change between communities this will make the analysis more difficult as each community has to be treated differently but this is easy to do in the survey form, just use a condition in the relevant column to only show the correct fields for each community.