Hello the community,
I’m facing two problems with cascading select questions.
Firstly, I successfully incorporated cascades select questions into a questionnaire being edited. I was able to see the questions in “preview” mode. But since then, I can no longer have the hand to work on the questionnaire. The questionnaire is in the list of projects of my kobotool account but when I want to modify the questionnaire, I no longer have the hand and I get the message below.
Secondly, I’m trying to edit cascades select questions with the same data mentioned above. Unfortunately, when a copy data from XLM form and past them in kobotool, these questions don’t appear in kobotool form. I receive the same message below.
My data sheet used to edit cascades select questions, contains around 10 departments, 80 municipalities, 500 arrondissements and 5300 villages. I have tried to edit a new project, using all of these data the problem remains. But if I select a few number of localities, cascading questions are edited successfully.
How can I resolve this problem?
@lius02, when you have that huge cascading select choices, the system may be very slow. Maybe you could use use the select_one_from_file question type and the CSV file to create a cascading select question. Here is a previous post which should help you design your survey project using the same:
I’ve tried your suggestions, but I’m a little confused. Indeed, I transformed in csv format, data of each locality corresponding to the levels of my cascading questions (Communes==> Arrondissements==> Villages). So I got three cvs files. Then I incorporated into the XLS form of my project, data relating to department level (“survey sheet” and “choice sheet”). I then uploaded the 3 cvs files into the Kobo platform. My concern is that I can’t generate the file that links Departement, Communes, Arrondissements et Village in cvs format (see images below relating to files intitled “Village_Code”, "Disctrict_Code…). How can I generate these files? Thank you for your help.
Dear @Kal_Lam. I understand the approach and the different forms to use. I read the messages, analyze and try to reproduce the forms and the shared images. But my challenge is the cvs file with the filter. I don’t know how to get the Village_Code.cvs file with the filter (Image 1) from the excel file (Image 2). How to generate this file automatically? I have around 5000 villages and cannot do it manually, inserting line by line; the filter as shown by the image1 . Thank you for guiding me.