topic Re: Error with one_choice field, external content, and pulldata() in ArcGIS Survey123 Questions

Error with one_choice field, external content, and pulldata()

se2539 — Mon, 31 Jan 2022 17:19:28 GMT

Running into an issue in Survey123 Connect with trying to pull in external content via a CSV file into the one_choice field and populating other fields using pulldata(). Basically, when I choose one_choice I get the following error; clearly it wants me to have the list name in the choices sheet.

But the weird thing is if I change the field type to just text, everything works fine and all fields populate with no issue.

Using the one_choice option, how do I point to the CSV file versus the choices sheet?

Re: Error with one_choice field, external content, and pulldata()

se2539 — Mon, 31 Jan 2022 18:30:24 GMT

So after doing a bit more searching, I believe I found the answer: external choice lists. Instead of using one_choice [list name], I was able to test select_one_from_file [file name.csv] and it did the trick.

I suppose the main issue I was getting hung up on was the video I was using an example makes it seem like the CSV file used in the pulldata() function auto-populated the select_one field.

Re: Error with one_choice field, external content, and pulldata()

LMedeirosUI — Wed, 02 Feb 2022 01:51:24 GMT

I think it is just because there is "name" in the select_one question in the XLS Form and "name" in the CSV file. But there is no pulldata() calculation for the ${store} question, so it couldn't have been using anything other than choice filters. What you wanted to do (and figured out) was actually an (informal) enhancement request by the first comment on the video.