The filter does not seem to work

[samuelansu]

This is Ansumana Kamara again. I am working on a project but I wanted the facilities to be filtered according to their district. The facilities are more than 1500. I have used this formular in both the choice_filter under the facility column: district=${district} and selected(${district},name). It does not work. I checked in the community for similar question and it was suggested to use the select_one_from_file cdc_Code. I have created a second file but unfortunately, I don’t know how to upload both files. Even the first file refuses to upload now. Please help!

Cheers
Ansumana

[Kal_Lam]

@samuelansu

The facilities are more than 1500

@samuelansu, for this large list of facilities, you will need to use an external CSV file as outlined in this post discussed previously:

Cascading Limitation

@dimesh, seems like you have a lot of choices in your cascading select option. Please be informed that in such cases you will need to use the external CSV to list the choices. You could overcome this limitation as outlined in the post discussed previously (using the select_one_from_file question type): Alternatively, you could also overcome this issue by using the select_one_external question type as outlined in the post discussed previously:

[samuelansu]

Yes they are - 1544 to be precise