Hi @Varun
I’ve been working on a similar problem for some of our projects too and managed to crack it a week or two ago. I’ve attached the very basics here of what I was using to combine cascading selects to filter a search from an external CSV.
I’m not 100% sure it will solve your issue, but it might give you some ideas of how it could work.
Major downside is that it ONLY seems to work in Enketo (web forms) for now, but there might be a way to make it work using ODK app. I haven’t been able to test that out yet. Other minor issues is that it doesn’t work with ‘preview’ version of the form and you can’t use the KoBo ‘Reports’ function either - you have to do a ‘Legacy’ version export of the data or pull it into some other data viz software.
Hope this is of some help to you and others looking at this issue in challenging circumstances!
Chris
EXAMPLE - Selects with Choice Filter Search with from_file.xlsx (41.2 KB) id_names.csv (8.8 KB)
