I am pre-populating a survey using the pulldata() function and was hoping to use it in conjunction with choice lists (in the event that the native data needs to be updated). It looks like this is not a possibility. In fact, pre-populated fields with type = text will no longer populate when the select_one feature is added to a different field using the pulldata calc.
Just wanted to let you know with the upcoming 3.16 October Release of Survey123 we have extended the pulldata() function to now include spatial searches and URIs (feature service URLs). You can find the latest announcements, documentation and test out the latest 3.16 beta builds via theEarly Adopter Communityto get early access to these builds.
I'm a little unclear on what you are asking. Select_one questions with choice lists can be used to select a value that then is used in subsequent pulldata calculations.
Are you asking about populating a select_one choice list's via an external CSV file? That is currently not supported- when implemented, the function name will be search(), in accordance with the XLSForm specification.
Thanks for the quick response. I have a list of assets that are being inspected in a CSV, and I have created choice lists in my xlsForm corresponding to several fields in that CSV. My hope was to use the pulldata function to prepopulate data, however, if at the time of the inspection the person conducting the survey determines the pre-populated value no longer applies, they'd simply choose the correct value from the drop down in that same field.
Thanks for the clarification. It sounds like you are being affected by a known issue - Survey123 currently does not support the calculation of select_one questions.
Hello! This post is a bit dated... trying this in v2.6.6 and noting the same behavior with not being able to calculate a select_one. has ths been addressed in a subsequent version? Thanks!
when can we expect the search() function to be available?
I have two surveys that rely heavily on address based location as well as what is currently in inventory. being able to search any external csv (that could then be updated) would make a world of difference for some of our fuctionality.
Hi Erick, I have exactly this problem too. We are trying to implement an asset tracking form, but being able to lookup a central CSV or database that can be updated would be perfect.
