XLSFORM select one from file, search and pulldata not working for external search/selection

User Support Form Building
,
1

Hello everyone,

I’m trying to create a form where the enumerator can search for an individual by name, last name, or ID, select them from a list (which comes from a CSV), and then record an activity. I am using XLSForm. (ex registro) with the thata (nombre and ID) and I have uploaded it correctly to the Media section of my form.

The main problem is that the syntax I’m using in my XLSForm isn’t working to populate the list of people with the necessary search functionality.

My goal is:

  1. To use the external CSV file (e.g., people.csv) as the list of options.

  2. To allow searching/filtering in that list by the CSV columns name, last_name, and unique_ID.

  3. Once the person is selected, to use pulldata to extract their name or ID into hidden variables.

Could you please point out the correct syntax I should be using in the select_one row to properly reference the CSV file and enable the search feature? I suspect I am incorrectly mixing pulldata with the selection function itself.

Thank you very much in advance for your help!

@Kal_Lam

2

@andrea_galeano, have you had a chance to go through this support article, Pull Data Functionality in KoboToolbox, to learn more about how the pulldata() function works.. You may also want to look through some previously discussed posts for a better understanding.!