AnsweredAssumed Answered

Creating a section to summarize total choices

Question asked by aabdullah@wwf.org.my_panda on Mar 30, 2019
Latest reply on Apr 1, 2019 by aabdullah@wwf.org.my_panda

Hello everyone!

 

I have a predicament with a survey form I am developing.

 

We're doing very detailed reef substrate checking.  We have 4 segments (which I conveniently separated into groups in this survey). Each groups have 20 intervals, thus containing 20 select_one questions. And each question ('select_one' question) has 10 choices of answers! Just explaining this is already scaring me a little. 

 

I am wondering if there is a possible way to calculate and sum the different choices accordingly at the end of the survey in a 'note' question type?

 

I've gone through some of the answers here, and I found something like the formula below:

 

if(selected(${question1}, 'yes'), 1, 0) + if(selected(${question2}, 'yes'), 1, 0) + if(selected(${question3}, 'yes'), 1, 0)

 

I am not sure which 'column' I'm supposed to type this into and typing out 20 questions times 4 isn't too practical! How do we go about this?

 

 

Any sort of input/hints would be super awesome and will really help us out. 

 

 

Azalea

 

xlsform survey123forarcgisconnect geonet survey123

Outcomes