It looks like what I want to achieve can be done, maybe. I have a CSV with company names and addresses. I'm looking for a way to pre-populate the section of my survey where it asks for contact info. The end users will generally be the same companies year after year. I'm designing the survey in Connect and will ultimately publish it as a Web App (v. 3.13).
Here's an example of what I mean:
(1) The user starts typing the name of the company the begins with "a". A list of those companies show up.
(2) When the user selects a company all contact boxes are filled.
According to this help doc, you won't be able to fill multiple boxes at one time:
The pulldata() function is best kept alone in the calculation column. Do not be tempted to combine multiple pulldata() calls within the same calculation. It will work in Survey123 Connect, but the Survey123 web app will not be as permissive.
I've also been referencing this help doc, but I don't quite understand it.
pulldata('info','email','name', ${previous_question})
- The name of the CSV file that contains the list of values. The name does not include the .csv file name suffix.
- The name of the column in the CSV file that contains the value you want to return.
- The name of the key field in the CSV file that you will use to look up the value.
- The key value to look up in the key field.
Looking at the parameters here, I understand what the first two are. What exactly are numbers 3 and 4? I've attached my XLSF and a shortened version of the CSV file (contacts_short.csv) that has the contact info.