Search Function

[brighton_zocs]

I am trying to develop a form that will use data from my previous Project. I have tried every example I have come across but it keeps giving me and error of missing CSV file. Could someone help me with restructuring my csv file and the form as well. I have attached the files I would like to use.
child_list.csv (3.5 MB)
search search().xlsx (17.2 KB)

Please help refine them so I could follow the Practical example from this file to complete my other projects. I want to use a CSV with multiple columns which allows me to link multiple beneficiaries to one School. I also want when the filters are done in the form, when a School name is selected, the next on the names of children, the list should only be filtered to the children in that school.

I will really appreciate

[Kal_Lam]

Welcome back to the community, @brighton_zocs! I see a lot of empty rows in your CSV file:

Could you remove those empty rows as a quick check to see how it behaves?

[brighton_zocs]

its actually not empty it has data already in all those columns
child_list.csv (3.5 MB)

[brighton_zocs]

[Uploading: Screenshot_20220301-1345

15_KoBoCollect.jpg…]

This is the error am getting on the form

[Kal_Lam]

@brighton_zocs, you have used child_list in the survey tab:

But the same name does not exist in your choices tab.

You could follow the instructions as outlined in the post discussed previously (maybe that should solve your issue):

Search() function with external CSV file

Hi @percezione, Try using the search search() function under the appearance as shown in the image below: Image 1 (survey tab): [Image%201] Image 2 (choices tab): [Image%202] Image 3 (csv file): [Image%203] Note: in your dataset you will see 1 if you select Apple, 2 if you select Watermelon and so on. However, if you wish to see Apple, Watermelon etc. simply type Apple, Watermelon under the name as well. Steps: Finalize your survey forms as shown in image 1 & 2. Finalize your choices …

[brighton_zocs]

Thank you really so much for helping me I really want to see this project work. I followed the steps in the post you have shared but only responded in one question and the rest had errors. the CSV that I shared has many columns and perhaps they help I need is to understand how I can use such a list to feed data into various questions of the form. or does it mean I need to do a separate CSV for every question and how should it be structured because I also tried that and didnt work?

[Kal_Lam]

Maybe you could break down the CSV file for other questions too.

[brighton_zocs]

let me try and see if it will work

[brighton_zocs]

am still getting that error

[brighton_zocs]

Ok I have split the CSV file into three and it was worked at least on two question while the other is still giving problems for what ever reason I am not sure.

[Kal_Lam]

@brighton_zocs, i have split the other half of your query here (for systematic documentation):

Adding cascading with external csv files

Now I need help with how to cascade so that when a filter is applied on the School, the list of children should be only for the children in that School