Use Cascading select with two condition

razaul.karim · September 7, 2024, 3:02pm

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

Kal_Lam · September 8, 2024, 5:55am

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.

razaul.karim · September 8, 2024, 4:43pm

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.

Bulbulrds · September 8, 2024, 5:39pm

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

razaul.karim · September 9, 2024, 3:59pm

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

Xiphware · September 9, 2024, 9:25pm

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.

razaul.karim · September 10, 2024, 2:32pm

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

Thanks again.

upazila_List1.xlsx (13.7 KB)

razaul.karim · September 10, 2024, 2:37pm

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

mdarshad17 · September 11, 2024, 5:35am

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:

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.
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