Cascade table import problem

Hello, I am trying to add a cascade table set of questions through the copy/paste option in KOBO. I have province, district then school but when I copy/paste then preview the questions, school does not show up. Anyone have suggestions?
sample data:

list_name name label province district
province attapeu Attapeu
province champasak Champasak
province vientiane Vientiane
province xiengkhouang Xiengkhouang
district samakkhixay Samakkhixay attapeu
district sanamxay Sanamxay attapeu
district sanxay Sanxay attapeu
district bachiangchaleunsook Bachiangchaleunsook champasak
district moonlapamok Moonlapamok champasak
district pathoomphone Pathoomphone champasak
district sukhuma Sukhuma champasak
district feuang Feuang vientiane
district meun Meun vientiane
district phonhong Phonhong vientiane
district thoulakhom Thoulakhom vientiane
district vangvieng Vangvieng vientiane
district kham Kham xiengkhouang
district khoune Khoune xiengkhouang
district pek Pek xiengkhouang
district phoukoud Phoukoud xiengkhouang
schools nakang Nakang 11006005 feuang
schools namai Namai 11006006 feuang
schools nathoun-namhai Nathoun-Namhai 11006034 feuang
schools nawane Nawane 11006030 feuang
schools pakhang Pakhang 11006020 feuang
schools phaluang Phaluang 11006080 feuang
schools phonhbeng Phonhbeng 11006029 feuang

Have you gone through our support article Adding Cascading Select Questions?

Besides, you could also follow our previous post that has a workaround on creating cascading select questions using the xlsform:

I have, and I followed the template.
I get province options to pop up, followed by district options to pop up, but nothing for schools.

Would you mind sharing your xlsform with the community?

I provided a sample of the dataset in my comment. The xls is quite lengthy, should I post or will the sample suffice?

@learntoread, you do not need to share the entire xlsform. You could share the ones that are needed to solve your issue. This should help to save the community’s time while supporting you.

Maybe you could follow the instructions outlined in the image shared below:

In the survey tab of your xlsform:

Image 1

In the choices tab of your xlsform:

Data entry screen as seen in Enketo:

Reference xlsform:

cascading select.xlsx (13.5 KB)

Thank you, I will try your suggestions.

1 Like