I have two survey questions that reference the same list_name values . I wanted to know if it was possible to exclude the question #1 answer from the list appearing for selection for question #2, so that the same value cannot be accidentally entered twice (select_multiple [list_name] will not work for my purposes). The answer to question #1 will change, so I need my list for question #2 to be variable. Both questions are currently set to "select_one".
So if my questions were:
What is your favorite ice cream flavor? Chocolate
Do you have a second favorite? Yes
What is your second favorite ice cream flavor? Strawberry (cannot choose chocolate again)
Is this possible or is there a better way to do this? (Note: This has to be appended to an existing geodatabase, so it's necessary that the questions/answers remain separate and match the existing schema/field names.)
Solved! Go to Solution.
Hi Danielle,
The mobile app currently does not support the syntax needed for this; the next generation web app does support this.
In the choice_list of your second select question, you would need
name != ${question1}
Hi Danielle,
The mobile app currently does not support the syntax needed for this; the next generation web app does support this.
In the choice_list of your second select question, you would need
name != ${question1}
Thanks for the quick response, James!
What do you mean by "choice_list"? Is this the same as "choice_filter"?
yep, choice_filter - my bad
Thanks!
Hi James Tedrick, is it still the case that the mobile app wont support this logic? I have the exact same requirement and am trying to build the logic into the form in Survey123 Connect however I am getting an error when converting the XLSFrom.
This is what my form looks like. Highlighted in red is where I'm trying to exclude the previous value entered.
Cheers,
Finnian
Hi Finnian,
Yes, the choice_filter at this time time does not support "not equals". The and part would work, however.