Use Cascading select with two condition

begin_group module_1 MODULE 1: false field-list
select_one resptyp resptyp Project Type true minimal
select_one district district District true minimal
select_one upazilla upazilla Upazila true minimal district=${district} and resptyp=${resptyp} ${resptyp} = ‘1’ or ${resptyp} = ‘2’
select_one union union Union true upazilla=${upazilla}
end_group
list_name name label district resptyp upazilla
district 1 Satkhira
district 2 Barguna
district 3 Patuakhali
district 4 Bhola
district 5 Lakshmipur
district 6 Rajshahi
district 7 Nawabganj
district 8 Bogura
district 9 Pabna
district 10 Dinajpur
district 11 Jamalpur
district 12 Kurigram
district 13 Gaibandha
district 14 Rajbari
resptyp 1 Treatment
resptyp 2 Control
upazilla 101 Kolaroa 1 1
upazilla 102 Kaliganj 1 2
upazilla 103 Barguna Sadar 2 1
upazilla 104 Kolapara 2 2
upazilla 105 Bauphal 3 1
upazilla 106 Golachipa 3 2
upazilla 107 Burhanuddin 4 1
upazilla 108 Bhola Sadar 4 2
upazilla 109 Roypur 5 1
upazilla 110 Laksmipur Sadar 5 2
upazilla 111 Godagari 6 1
upazilla 112 Bagmara 6 2
upazilla 113 Shibganj 7 1
upazilla 114 Nawabganj Sadar 7 2
upazilla 115 Shibganj 8 1
upazilla 116 Sherpur 8 2
upazilla 117 Sujanagar 9 1
upazilla 118 Ishwardi 9 2
upazilla 119 Chirirbandar 10 1
upazilla 120 Ghoraghat 10 2
upazilla 121 Islampur 11 1
upazilla 122 Sreebardi 11 2
upazilla 123 Nageshwari 12 1
upazilla 124 Ulipur 12 2
upazilla 125 Sundarganj 13 1
upazilla 126 Palashbari 13 2
upazilla 127 Rajbari Sadar 14 1
upazilla 128 Goalanda 14 2
union 10101 Chandanpur 101
union 10102 Deara 101
union 10103 Koyla 101
union 10104 Helatola 101
union 10105 Jalalabad 101
union 10106 Joynagar 101
union 10107 Jugikhali 101
union 10108 Kerakati 101
union 10109 Keralkata 101
union 10110 Kushadanga 101
union 10111 Langoljhara 101
union 10112 Sonabaria 101
union 10201 Bharasimla 102
union 10202 Bishnupur 102
union 10203 Champaphul 102
union 10204 Dakshinsreepur 102
union 10205 Dhalbaria 102
union 10206 Krishnanagar 102
union 10207 Kushlia 102
union 10208 Mathureshpur 102
union 10209 Motala 102
union 10210 Nalta 102
union 10211 Ratanpur 102
union 10212 Tarali 102

Welcome to the community, @razaul.karim! Could you outline what should appear when you select something? Maybe share with the community a condition so that the community should be able to understand and help you out.

Thank you for your reply. I have a database where every district has two types of upazila (Treatement and Control). Now how can I cascading upazila and also type of upazial under district. Thank you again.

Hi @razaul.karim
Please share your XLSFORM, i will help you.

1 Like

As new, I can’t attached xlsform. I have a database where every district has two types of upazila (Treatement and Control). Now how can I cascading upazila and also type of upazial under district.

Thank you.
Raju

I’ve bumped up your level. Can you perhaps try uploading your xlsform now and explain what you are trying to do with it, thanks.

1 Like

Thank you very much for the level up. Here I am attaching the file.

Thanks again.

upazila_List1.xlsx (13.7 KB)

It’s amazing. Thank you all for your quick response and for the effort to backup someone new like me.

1 Like

Dear @razaul.karim Bhai,
Hope you are doing well.
You have done everything correctly. However, I have made corrections and highlighted in yellow for your understanding. Please find attached the file for your future work.
upazila_List1.xlsx (13.6 KB)
I have some observation which I am giving below for your kind information:

  1. As you have the same districts for treatment and control, you do not need to put two districts filtering (dist_1, dist_2) according to type.
  2. We apply ‘relevant’ when you need some data input based on any criteria of previous questions or when we need to skip.

Hope it will be helpful for you. Please let us know if you need any support.

Best regards,
Arshad

1 Like

@mdarshad17, :bowing_man: :heart:

thank you for your support. But still I face problem.

@razaul.karim, I did not have any issues validating the XLSForm shared by @mdarshad17!

I did not have any issues uploading them to my account.

And here is the Enketo form:

1 Like