Hello James! James Tedrick
Thank you for clarifying the method above. My question is, if there are alot of 20 questions which will have the same limited multiple choices (eg. 4 choices; A, B, C, D). Is there any other possible way to 'filter' and sum the different choices accordingly without having to type such as you've suggested:
if(selected(${question1}, 'yes'), 1, 0) + if(selected(${question2}, 'yes'), 1, 0) + if(selected(${question3}, 'yes'), 1, 0)
We're doing very detailed reef substrate checking. We have 4 segments (which I conveniently separated into groups in this survey). Each segments have 20 intervals which are the 20 questions I've mentioned earlier. And each question ('select_one' question) has 10 choice of answer! Just explaining this is already scaring me a little.
I was wondering how to go about this.
P/S: I don't even know where to type the function you've shared although I understand the gist of the solution.
Any sort of input would be super awesome and will really help us out.
Azalea