Dear community,
I would like to create a cascade-select question using XLS forms.
I have followed the exact instructions/templates given in previous posts in the community.
When I copy-paste from Excel in the form builder, the cascading question appears correctly. However, when I use exactly the same data and paste it in my XLS questionnaire and then upload that, the answer options of the last question do not appear in the app.
- I have created a seperate Excel with the data for the cascading question (region, province, commune)
- I have pasted this in the “choices” tab in my XLS form
- I have inserted the choice filter in the “survey” tab (region=${region_1} ; region=${region_1} and province=${province_1}
- I have uploaded my XLS and delployed the survey
- When I open the form in the kobocollect app on my phone, I can select the region and then the province, but the choice options for the commune (the 3rd step of the cascade) do not appear.
Could anybody help me trouble shoot ? @Kal_Lam I tried to upload the XLS file but I’m getting the notification that new users are not allowed to upload a document…??
Many thanks!