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?
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
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.
