@ivanradisson, maybe you could use the username form metadata with the pulldata as shown in the image shared below:
In the survey tab of your XLSForm:
CSV file:
Configure your Collect app’s Metadata:
The username should match the name in CSV file.
Screen as seen Collect android app:
Here the username is pulled automatically. You need not type the name manually.
Screen as seen Collect android app:
These are the details pulled automatically by the pulldata function.
Reference XLSForm:
Pull Data (Username).xls (33 KB)
CSV file:
Codes.csv (145 Bytes)
With this approach, you will not need to filter the details like you generally do with the cascading select. The pulldata function helps to filter out all the details that are only required which matches the username metadata.
Also please note that this approach best works with Collect android app as you are able to configure Metadata (as outlined in our support article here) that matches the name which you wish to use as names that should filter out the details. You could also use Enketo here but Enketo should pull the account name while using the username hence it only works if the account name matches the username that is being used in the CSV file.
