# Cascading Select conflicting **URL:** \ **Category:** Support\ **Created:** [September 11, 2019, 4:48pm UTC](https://forum.getodk.org/t/cascading-select-conflicting/22017 "2019-09-11T16:48:14Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![A.N.M\_AL-IMRAN](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/a.n.m_al-imran/32/1610_2.png) [@A.N.M\_AL-IMRAN](https://forum.getodk.org/u/A.N.M_AL-IMRAN)\ **Post date:** [September 11, 2019, 4:48pm UTC](https://forum.getodk.org/t/cascading-select-conflicting/22017/1 "2019-09-11T16:48:15Z")
Hi All, I am working on a form: [client\_locator\_form2.xlsx](https://forum.getodk.org/uploads/short-url/uK6e41GgpjfN5gFTOamFRWFHOfD.xlsx) (18.1 KB). I have a few questions as the following: - When I am using cascades, the options are appearing as expected - I need to have the location selection option twice and I tried to achieve that in the following ways - By adding the choice filter option - Adding another cascades tab - Or Reusing same cascades twice (not sure how to do that) - When I am using cascades and choice filter together, its conflicting with each other Help will be highly appreciated. I am completely stuck at this point. Thanks, Imran ---
**Author:** ![anon5185938](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/a/eada6e/32.png) [@anon5185938](https://forum.getodk.org/u/anon5185938)\ **Post date:** [September 13, 2019, 2:10pm UTC](https://forum.getodk.org/t/cascading-select-conflicting/22017/2 "2019-09-13T14:10:08Z")
@A.N.M_AL-IMRAN: I am currently reviewing your file. Please, by location selection, are you referring to the recording of GPS or selection of your districts, sub-county and their corresponding health facilities? ---
**Author:** ![anon5185938](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/a/eada6e/32.png) [@anon5185938](https://forum.getodk.org/u/anon5185938)\ **Post date:** [September 13, 2019, 2:47pm UTC](https://forum.getodk.org/t/cascading-select-conflicting/22017/3 "2019-09-13T14:47:49Z")
@A.N.M_AL-IMRAN: Please, find attached my review of your file. My inputs are in red bold fonts. Kindly check all 3 sheets. Thank you. [fad\_client\_locator\_form2.xlsx](https://forum.getodk.org/uploads/short-url/754WgHlnXXtJCiHRUjYXxD8DnHA.xlsx) (19.9 KB) ---
**Author:** ![A.N.M\_AL-IMRAN](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/a.n.m_al-imran/32/1610_2.png) [@A.N.M\_AL-IMRAN](https://forum.getodk.org/u/A.N.M_AL-IMRAN)\ **Post date:** [September 16, 2019, 4:26pm UTC](https://forum.getodk.org/t/cascading-select-conflicting/22017/4 "2019-09-16T16:26:02Z")
Thanks, @anon5185938. However, I am trying to have option as the following: - I need have option to insert Province\>District\>Subcounty etc. twice. First I need to add that as address of the facility and secondly as the address of the patient. And I have tried to achieve that is different ways; however, they are conflicting with each other. Is there any way to use cascades sheet twice? Help from anyone will be highly appreciated. Thanks once again, Imran ---
**Author:** ![anon5185938](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/a/eada6e/32.png) [@anon5185938](https://forum.getodk.org/u/anon5185938)\ **Post date:** [September 16, 2019, 7:17pm UTC](https://forum.getodk.org/t/cascading-select-conflicting/22017/5 "2019-09-16T19:17:16Z")
Hello @A.N.M_AL-IMRAN! Do you want the address of the facility to be same as the address of the patient? If yes, you can pull the initial selections of Province\>District\>Subcounty etc and use the acknowledgement feature. That would avoid conflict of chosen options. In my attached file, you may check row 2, 20 and 21. [fad2\_client\_locator\_form2.xlsx](https://forum.getodk.org/uploads/short-url/ksO2zzuqQ3uaX60qSK5ZckQ5zwR.xlsx) (19.5 KB) Thank you. ---
**Author:** ![A.N.M\_AL-IMRAN](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/a.n.m_al-imran/32/1610_2.png) [@A.N.M\_AL-IMRAN](https://forum.getodk.org/u/A.N.M_AL-IMRAN)\ **Post date:** [September 16, 2019, 8:04pm UTC](https://forum.getodk.org/t/cascading-select-conflicting/22017/6 "2019-09-16T20:04:19Z")
Dear @anon5185938, Thanks so much, the tips are very helpful. However, I am looking for actually inserting the data twice. I need to insert Province\>District\>Subcounty\>Health Facility then for Patient I need to insert Province\>District\>Subcounty. I know it does not sound practical, but thats our requirement at present. When I am trying to call the lists twice, I am having an issue with the form. Two lists are conflicting with each other. Is there any way that I can use cascades twice? On first stem I want insert Province\>District\>Subcounty\>Health Facility and then on second step Province\>District\>Subcounty. Thanks again, Imran ---
**Author:** ![LN](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ln/32/1605_2.png) [@LN](https://forum.getodk.org/u/LN)\ **Post date:** [September 16, 2019, 8:57pm UTC](https://forum.getodk.org/t/cascading-select-conflicting/22017/7 "2019-09-16T20:57:11Z")
@A.N.M_AL-IMRAN where did you come across documentation for `cascading_select`? I see that it's in `pyxform` as a convenience generator for cascading selects but it's not in any documentation that I can see. For example, the XLSForm website shows how to build the cascade from a series of choice filters: [http://xlsform.org/en/#cascading-selects](http://xlsform.org/en/#cascading-selects). Looking at the form, it looks to me like you want to go through the province \> district \> subcounty selection twice because the health facility and the client may not be from the same place, right? That would be a totally reasonable requirement. In that case, you want to ask for two unrelated provinces, districts and subcounties and use separate filters. [client\_locator\_form2.xlsx](https://forum.getodk.org/uploads/short-url/a9pm1gbXUpJwg7g5C3wbaNSzVPC.xlsx) (10.9 KB) is an example that shows this. The changes I made: - removed usage of `cascading_select` because it doesn't give enough control - added health facilities to your choices sheet - gave different names to the values collected for the facility and the client (e.g. `hf_region` and `client_region`) - adjusted the choice filters for each cascade to use the appropriate values. For example, `region=${hf_region}` filters down the districts based on the health facility region provided and `region=${client_region}` filters down the districts based on the client region provided ---
**Author:** ![A.N.M\_AL-IMRAN](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/a.n.m_al-imran/32/1610_2.png) [@A.N.M\_AL-IMRAN](https://forum.getodk.org/u/A.N.M_AL-IMRAN)\ **Post date:** [September 17, 2019, 2:41pm UTC](https://forum.getodk.org/t/cascading-select-conflicting/22017/8 "2019-09-17T14:41:05Z")
Dear @LN, Good question! In fact I am also confused about the cascades sheet. I found this cascading\_select from one of my colleague and I was wondering where has he got that form? And that is still a big mystery to me as I never found it anywhere in the ODK documentation! I have no idea but I really liked it and it looks more convenient and I adopted that. However, initially, I used to follow the choice\_filter as describes on your link. Thanks so much for such great support as always. My issues have completely been resolved. Special thanks to @anon5185938 for being so supportive. Thanks again, Imran