Cascade select using external csv

[17dan1991]

Dear all,

I hope someone could help me with a challenge I am facing at the moment.

I am developing a form where the first question is:

Q1: “In which country did you start your trip?” (with 5 possible options)

Then I have a second and a third question where I ask about the admin levels of departure. I know this can be done using a cascade, but because I have more than 8,000 rows, I need this to be in a separate CSV. It works fine when I do not add the expression in the [choice_filter column], but when I add the expression in the [choice_filter] column it does not work.

Ideally, if you chose Cuba as a country of origin, only admin 1 for Cuba should appear in Q2, and then only admin 2 within the admin 1 for Cuba should appear in Q3.

Any help will be much appreciated.

Best

admins.csv (664.4 KB) search_function_cascade.xlsx (14.1 KB)

[stephanealoo]

Hi @17dan1991
I believe the discussion below would be of help in resolving your issue.

Managing cascading select questions for a very large question choices

Hi @cchukwu I would like to propose an entire different approach to getting this form to work. This will however require that you do some work on your end to customize the form on the cascade selection using the following instructions. Approach 1: Using search () in the appearance column. NOTE: This method will only work on the android collect application. The original writeup can be found here (XLSForm Docs). This method does not need you to execute choice_filter for cascade questions …

Stephane

[17dan1991]

@stephanealoo Many thanks for your quick answer.

I am struggling a bit with understanding this.

Would you be able to kindly share the examples of that xls and csv that you illustrate in the images?

Many thanks for your kind support

[stephanealoo]

Hi @17dan1991
Find below the XLS form

Select One and Multiple from CSV.xlsx (12.2 KB)

countriesbyregion.csv (36.9 KB)

[Kal_Lam]

As a backup, kindly please be informed that you could also cascade choices using select_one_from_file as discussed previously:

Select_one choice filter from another select_one

Hi @esmatullaharifi, Welcome to the community! You could design your survey form with the cascading select question to get what you have tried for by following the support article here. As a backup you could also have a look at the post that has a simple workaround that should help you understand the concept of cascading select question: But looking at your xlsform, i see there are more then 800 choices which should affect your data entry performance. Thus a solution for this could be design…