Hi,
I am working on a household survey for food consumption.
We would like to ask:
- How many meals did you have yesterday?
Then have a repeat group with a fixed number of repeats (the number of meals):
And another repeat group inside, not fixed number, to add as many food item as wanted and ask a group of questions:
- What food category? (select from list: meat, vegetable…)
- What sub-category? (select from list: mammal, bird…)
- What group? (select from list: ongulate, primate…)
- What specie? (select again from list)
These latest 4 questions are all in cascade select, so 3 levels of cascade.
Building the form like this with 2 repeat groups and the multiple cascade selection does not work. I have an error message when trying to deploy : “500 servor error”
Then I tried to get rid of the 1st repeat group, to ask:
- What meal did you had yesterday? (select multiple: breakfast, lunch, dinner…)
And then a group of questions for each meal, with just one repeat group for the food items.
I had a message saying that a “cascading choices can only reference one choice list”, so I split up all the choices filter in multiple columns.
It is still not working : if I select more than one meal, all the questions to select the food item do not appear.
Any advice?
The last versConsumption tool_190325.xlsx (110.9 KB)
ion of the form is attached.
Thanks
Best
Diane