How to create a cascading select question?

Another topic like that
I select the ( row 2)
I want to data validation criteria set in row 12
If ( row 2) then row 12(selection-1) is greater or equal to 2009 and less than or Equal to 2016
If ( row 2) then row 12(selection-2) is greater or equal to 2017 and less than or Equal to 2020

What is the statement for that which I want to put in the Validation Criteria

Could please help???

BSC_Share.xlsx (96.1 KB)

Sorry not still clear? Could you simplify it again!

Lets

Qestion.1
Select your Upazila

  1. New Upazila
  2. Old Upazila

Question. 2 CIG Fomation Year
Select the Year

  1. 2009
  2. 2010
  3. 2011
  4. 2012
  5. 2013
  6. 2014

In the data validation criteria
New Upazila must 2009 to 2011
Old Upazila must 2012 to 2014

Someone have to select within the range

I can not understand statement for that could you plz provide the statement.

This is called cascading select. You could learn more on the same from our support article Adding Cascading Select Questions.

You could solve your case as outlined in the image shared below:

In the survey tab of your xlsform:

Image 1

In the choices tab of your xlsform:

Image 2

Data entry screen as seen in Enketo:

Data entry screen as seen in Enketo:

Reference xlsform:

Cascading Select.xlsx (12.0 KB)

1 Like

Dear Sir,

Thank you for the demonstration, I tried to do the same, however, it turnsed to empty for all choices. May I share my cascading table in the link? Cascading.xlsx - Google Drive

Could you give me feedback on why my questionnaire can not add this cascading selection.

Regards
Vilon