In cascading select, I have an reply option "N/A" that needs to be visible for all the choice filters

[arteseflorinda]

I have a list of state, townships and villages and they are all sorted with choice filter for cascading selects, but I want to add a reply option “N/A” that is possible to select always ( for all the states and townships)

[Kal_Lam]

@arteseflorinda, you should be able to do it as outlined in this post discussed previously:

How to keep some choice(s) visible at all times with the aid of a cascading select function?

Well this is very clear now. You could do the same as outlined in the image below: In the survey tab of your xlsform: [Image 1] In the choices tab of your xlsform: [Image 2] In the settings tab of your xlsform: [Image 3] Data entry screen as seen in Enketo: (when a condition is not met) [Image 4] Data entry screen as seen in Enketo: (when a condition is met) [Image 5] Reference xlsform: Cascading Select.xlsx (13.3 KB)

[arteseflorinda]

Sorry but I don’t understand your reply. N/A is not guided from conditions, but it should be visible always, as not part of the choice filter replies.

[Vlad_Dn]

Hi. Maybe my option is right for you. I think you are describing the same problem I had.

Сhoice filter with one regular option

Hey, everybody. Based on the fact that I have not received any suggestions to solve this issue. I have found a solution on my own. Maybe this issue is not so interesting for other, more advanced users, but hopefully my solution will help newbies like me. Here is the solution: To solve this problem, you need to write the formula “contains(“A”,${B})” in the “survey” tab in the “choice_filter” column. Where A is the name of the filter column in the “choices” tab and B is the name of the questi…

[arteseflorinda]

Sorry, but I am not able to follow your advice. I need an option “N/A” that it is visible always.

As I have more than 9000 village, village tract, etc. options I cannot include N/A for all the filter choices.

See the screenshots:

[hakan_cetinkaya]

@arteseflorinda, @Vlad_Dn’s approach will let you achieve what you are looking for.

[arteseflorinda]

I cannot add “Canada France USA” in the “filter” columns in choices sheet as I have more than 9000 villages, village tracts, etc.

Is it the only solution?

[hakan_cetinkaya]

@arteseflorinda, well before @Vlad_Dn’s approach the concensus was Kal’s approach (adding the required answer to each cascading selection and allowing choice duplicates)

As a workaround, do you think adding a simple yes / no question before your township, ward, village tract and village questions? So you can create relevant conditions for those levels, and ask the information afterwards?

[arteseflorinda]

Dear all,
At the end we removed the true in “required” and decided to leave it empty if N/A.

Thank you all for kind support!