AnsweredAssumed Answered

What's the best way to set up a dynamic survey?

Question asked by alex.damiao@cortlandpartners.com_cortlandpartners on Mar 18, 2019
Latest reply on Jun 18, 2019 by alex.damiao@cortlandpartners.com_cortlandpartners

I have a survey with about 250 distinct questions which are all of the yes/no type. The idea of the survey is that a subset of these 250 questions will only appear if they are applicable (depending on a "condition" chosen by the person filling out the survey. Let's call these conditions 'condition_1', 'condition_2',...,'condition_150').


For example, if a person starts the survey and selects 'condition_22', then the survey will only show yes/no questions for what makes sense under that condition (could be questions 3, 67, 98, 99, 143).


So, my approach was to use the relevant column and insert the conditions there. I insert all 250 questions in the "survey" tab of the xlsform and fill out the "relevant" column accordingly. So for example, if question 30 is applicable only under conditions 23, 57, 129, my relevant column would look like:

${variable}='condition_23' or ${variable}='condition_57' or ${variable}='condition_129'


For the dataset that I have, some questions appear for all 150 conditions, so you would have ${variable}='condition_1' or .... or ${variable}='condition_150'.




I implemented this survey and what I've been finding out so far is that the phone app and the Survey123 Connect for ArcGIS are both having trouble loading it up (it crashes 9 out of 10 times, making it unreliable for this task). The browser version doesn't crash, but it doesn't work properly. There is a noticeable performance drop (it takes about 20 seconds just to load the conditions you choose from) which I currently cannot get around.


Am going about this wrong? Is there something simpler that I didn't realize I could've done instead?


Thank you in advance!