Hello
I have an .xls form that has a series of about 20 questions that all use the same list name for a choice list. The user is able to select from 4 options for each of these 20 questions.
The options are numbered 1,2,3,4.
What I want to do is put a restriction that a user can select multiple answers but cannot select the combinations 1&2, 2&3, 1&3 ie. the only combinations allowed are 1&4 or 2&4, however the user can still select individually options 1,2 and 3.
I am designing the form in excel and using ODKCollect v1.10.2 to run it
I have tried to use the constraint field to solve my problem with 'and' and 'or' operators, which leave me with a lengthy field that has to be repeated for all 20 questions with the new variable name eg:
(selected(${variable},1) and selected(${variable},4)) or (selected(${variable},2) and selected(${variable},4)) or selected(${variable},1) or selected(${variable},2) or selected(${variable},2)
Looking forward to some colorful solutions.
Thanks