Solution on cascading or drop-down

Hello everyone, my name are Adebayo Adewale and am new here. I have been trying to create or build a form with excel spreadsheet but my greatest challenge has been on how to create a cascading or drop-down. Pls I will be grateful if anyone can be of help. Thanks

See this helpful document http://xlsform.org/en/#cascading-selects

and there you can find a sample form https://docs.google.com/spreadsheets/d/1CCjRRHCyJXaSEBHPjMWrGotnORR4BI49PoON6qK01BE/edit#gid=2

1 Like

Hello Sir, my name are Adebayo Adewale and am new here. I have been trying to create cascading or drop-down and to terminate question if you say No in my ODK build and all my effort are all in vein to get this done. Pls, I will be glad if you can proffer solution to this regard. Thanks

Hello everyone, my name are Adebayo Adewale and am new here. I have been trying to create or build a form with excel spreadsheet but my greatest challenge has been on how to create a cascading or drop-down. Pls I will be grateful if anyone can be of help. Thanks

See this xls form development document http://xlsform.org/en/#cascading-selects

Dear KHAN, I deeply appreciate your urgent response. But I have tried the both in the file you attach to me and other ones I have come across on this platform. I wish and pray you can make it in an excel file for me.

Search in the forum for your desired answer, i believe you will get your answer https://forum.getodk.org/search?q=cascading

Welcome to the ODK forum, @Adebayo_Adewuyi! We're glad you're here. When you get a chance, please introduce yourself here. I'd also encourage you to add a real picture as your avatar because it helps build community!

Please try to not create duplicate posts asking the same thing. Everyone on the forum is a volunteer, and sometimes you may have to wait some time for an answer.

Also, the forum is for asking questions and tackling problems. We're happy to help you find the right resources but it's generally not a place to get have someone create a full solution in Excel for you. Please read the documentation links and look at the examples the others have posted. If you still can't get it to work, please provide more details about what you have tried and what didn't work.

2 Likes

Hello Nik Go, I am having a similar problem as regard to cascading. Pls help me if you have solution to the problem. Thanks

Lga_Facility_Test.xls (28.5 KB)
I have tried all my possible best to get pass this last part of xml cascading. I will be glad if anyone can help me out.