Dear colleagues, I need your help with an issue I’m encountering. I copied several answers or options from an Excel sheet and pasted them into the ‘Import Cascading Select Questions’ box in KoboToolbox. However, when I attempted to paste this text into the related questions in Kobo form, the options\answers did not appear. Could you please assist me in resolving this? Thank you.
@aminabualsoud, are you using the cascading select template from our support article Adding Cascading Select Questions?
@Kal_Lam: Yes, I have just started using the cascading select template from the support article, but I’m still struggling to get it working correctly. Even though I’ve created the Excel file, copied and pasted the data, and linked the questions, the display isn’t working as expected. I find myself having to repeat the process multiple times.
https://drive.google.com/file/d/171hFuensyyLh-3gAR7yCWffu9UCog0Xf/view?usp=drive_link
@Janna Rous: access to the file has now been granted for anyone who is willing to assist in resolving the issue and helping to create the cascading questions. Your support would be greatly appreciated.
Hello @aminabualsoud ,
I assume you are looking for choice filter. From the csv file that you had shared,
I had made the excel file for you reference attached down below, where District is filter from the Region,
If West bank is selected, option Bethlehem will shown in District and based on district selected, the option of locality is shown.
Hope this works out for you.
townlabelsfinengfinal.xlsx (18.2 KB)
Regards,
Dinesh Dongol
1 Like
Thank you very much for the modified Excel file. As I am new to Kobo Toolbox, please excuse me if I ask some basic questions. My plan is to open the Excel file, then copy and paste the information along with the table titles section by section. After that, I will make the necessary adjustments within the question boxes, such as using formulas like region-filter=$(region), etc. I will leave the information in the first worksheet unchanged and won’t copy and paste it. Is that correct?
Sorry @aminabualsoud,
I didn’t quite got your question about it ?
1 Like
I followed the necessary steps as outlined. Please check the video linked below to see the output after inputting the data. However, I encountered an issue with saving the project—I received a message indicating that the project could not be saved. The internet connection at my office is working well, so I’m unsure what might be causing the problem. Could you please advise on how to resolve this? Thank you.
Link: [demo.mp4 - Google Drive].
I assume its is issue of internet. Sometime it happened on my end as well.
Other wise than that, I didn’t see any issue on it.
For Cascading selection question, its better to make in excel and upload later in the interface as you had done.
1 Like
@Dnes: thank you for your valuable feedback. Interestingly, when I delete these newly added questions and save the project, it works fine, which suggests the issue might be related to the newly entered questions. I’ll keep experimenting to identify the root cause. Any additional insights you might have would be appreciated as I continue troubleshooting.
Thank you for your support.
Hi @aminabualsoud,
When you’re making your formulas in the Choice Filter, make sure you’re using curly brackets instead of normal brackets, for example: region-filter=${region}.
Also, as in @Dnes 's example XLSForm, it looked like the thing you were missing from the cascade select table that you initially shared was a column titled ‘name’. Check that out in the support article that @Kal_Lam shared, it seems you don’t have that column in your Google sheet.
What you could do is also attach your XLSForm of your questionnaire, if you still can’t get it to work, and we can help you modify it directly so you can see.
Hope these tips are also helpful!
Janna
1 Like
Dear Ms. Janna,
Thank you so much for the helpful tips! I have attached ([file-1+ file-2) two files for your review and assistance. The second file includes both Arabic and English, and I would be grateful if you could ensure that both languages are functioning correctly for the cascading question.
Your support is much appreciated!
[File-1] (Loading Google Sheets).
Best kind regards,
Amin
Dear Ms. Janna,
Thank you so much for your helpful tips! I posted two Excel sheets for your kind review and support. I would really appreciate it if you could take a look and assist me with modifying them as needed. I am wondering if I can also insert a column for Arabic language? Looking forward to your feedback.
Best kind regards,
Amin,
@aminabualsoud, after creating your XLSForm you could always validate it through the online validator to see if any syntax issues in it are affecting the deployment.
If you are still stuck and would like to get support from our community, I could change your post to Job Board meaning that anyone interested in the community could help you out.
Otherwise, if you wish to learn things by yourself, you will need to make small forms (with one or two questions and a small list of choices) first and then test them through the online validator to see if everything is OK.
Dear Mr. Kaylan,
Thank you very much for your previous feedback. I tested the attached Excel file using the recommended online validator, and it appears to work correctly. However, when I copy and paste the contents of the Excel file into the Kobo form, particularly in the “Insert Cascade Select” section, and press “OK,” only the first question appears. Furthermore, when selecting an option for the first question, it doesn’t display the subsequent cascading options as expected.
This issue seems quite unusual. I have watched several tutorials and followed the recommended procedures step by step, but unfortunately, the form is still not functioning as intended. I would greatly appreciate your assistance in resolving this matter.
Additionally, I would like to know if it is possible to add an additional language (e.g., Arabic) in the same Excel file for multilingual support.
Please find the attached Excel file for your review.
Thank you very much for your help and support.
Kind regards,
Amin
(attachments)
12092024-townlabelsfineng_final-2.xlsx (18.3 KB)
@aminabualsoud, I see that your cascading select works as expected. Maybe download your other survey questions and then copy and paste those questions to this cascading select questions (in the XLSForm). Then test the updated XLSForm through the online validator again and upload the new updated XLSForm as a new project. Maybe that would be an easy approach for you.
Dear Mr. Kaylan,
I am so sorry, I tried the suggested approach of downloading my other survey questions and copying them into the XLSForm with the cascading select questions. However, I still haven’t had any success. If there are any additional steps or tips you can share to help resolve this issue, it would be greatly appreciated.
Best kind regards
Amin,
Dear Mr. Kaylan,
I hope this message finds you well. I wanted to follow up regarding the issue I previously mentioned with the cascading select questions in my XLSForm. Unfortunately, despite trying the approach you suggested, the problem is still persisting.
I have also reached out to the community and the support team, but I have not received any assistance so far. If you have any further advice or tips that might help resolve this, I would greatly appreciate it.
Thank you again for your time and support.
Best kind regards,
Amin
@aminabualsoud, maybe you will need to go through this site to learn more on the XLSForm. Let me know if you need support. I could change the post to Job Board.
@Kal_Lam, thank you very much for sharing the useful site on XLSForm! I’ll definitely take a look. I appreciate your support and will let you know if I need any assistance. Thanks again!
1 Like
