I have watched the youtube video about enabling csv data for use in Survey 123 and have tried setting up my XLS Form the same way but still get the Error 'row 2 : list name not in choices sheet'
In the situation you describe, you would want the first question to be a select_one. You then would have a list in the choices worksheet to populate the select_one. I might suggest taking a look at the 'Calculate location from CSV' survey in the Create New Form > Samples group - you can find it by searching for 'pulldata' - that form has exactly the structure you want.
It sounds like your first question in the sheet is a select_one or select_multiple question? Are the valid choices for that question in the 'choices' worksheet in the XLS file?
I guess that is kinda my question. If I am pulling data from the csv form, what data needs to be in the choices sheet of the XLS Form?
Yes my first question is a select_one question? Do I need to put a list of available answers in the choices sheet?
Sorry for the ignorant questions but this is my first time fooling with Survey 123
Is the first question the one you want to lookup data into? If so, it should not be a select_one - it should be a text question. That being said, normally the first question is not the question that uses pulldata() - you normally need to have a question previous to get a value to lookup against for pulldata to work.
A pattern I commonly use is to have a select_one question with the id values so that when selected, a lookup is guaranteed to suceed. That requires the id values (and label) to be filled in the choices worksheet (along with a choice name used to reference it). Take a look at XLSForm essentials—Survey123 for ArcGIS | ArcGIS for getting start with select_one questions.
I want to lookup attributes from the csv file based off a Unique ID. So I want my first question in the survey to be in the form of a drop down menu with the drop down menu populated with the Unique ID's from the csv document. My first row in the survey sheet reads:
text | identifier | UniqueID
But this is only giving me a blank text box on the form to enter a value into. How do I populate it with the Unique ID's from the csv document
Thanks James! I got it to work by following that example
Retrieving data ...