1. What is the problem? Be very detailed.
I'm trying to make a cascading select between observer and the company they working in.
i want to have the possibility to select first the company (one or more) then one or more observer that work in the selected company. The issue is that the company list is in a csv file place in the media folder as well as the observer list but in a different csv file (in the same media folder).
when i try with choice_filter, it doesn't work : in ODKCollect i'm able to select observer that normaly would not appear because they don't work in the company i had preselected (basicaly, the filter do not work and all the observer are selectable)
i believe that it is possible to use the 'maches' with search function in the column appearance, but i want to kown if it is possible with the choice_filter option.
2. What app or server are you using and on what device and operating system? Include version numbers.
ODK Collect v1.21.1
3. What you have you tried to fix the problem?
4. What steps can we take to reproduce the problem?
try with my files
5. Anything else we should know or have? If you have a test form or screenshots or logs, attach below.
and my media folder (csv):
Thanks in advance for your time