I've a CSV file with a list of ID numbers. What I'd like to do is to read the column ID from the CSV and load all the values in a "select_one" combo on my form in Survey123.
I know how to read the CSV file using "pulldata" function and "calculate" field in my XLSForm to retrieve values according to a key, but in this case there is no key: I just want to load a list of data reading an external file, instead of copying all the data in my "choice" sheet of the XLSForm. I've tried using pulldata in "constraints" field but without success....
Any ideas? Thanks a lot
Unfortunately, we do not support the functionality as you describe it at this time. The closest would be to implement the values you describe as external selects, which as you note requires copying the values into the XLSForm. I've added your request to enhancement for a 'search' function, which would implement what you describe.
Just letting you know that in the latest 3.12 beta builds available on the Survey123 Early Adopter Community we have made significant improvements to large choice lists which improve the survey load time in both Connect and the field app.
On top of this there are now some new ways you can manage your choice lists dynamically and update them without having to republish the survey, meaning choice lists can now be populated and updated dynamically from a CSV file or hosted table shared in ArcGIS or directly from a feature service using the search() function. Please check out the latest announcement on EAC and test out these new beta features with the latest 3.12 beta builds.