topic Re: Use existing data in your survey - the pulldata( ) function in ArcGIS Survey123 Questions

Use existing data in your survey - the pulldata( ) function

dwold — Tue, 16 Jul 2024 19:43:23 GMT

I am trying to pull data from a excel file in my media folder to populate a note/text field. I am having issues getting the value I need to render in the form. See anything I am doing wrong?

survey tab:

dwold_3-1721158879296.png

choices tab:

dwold_2-1721158831892.png

Pull Table (CoreCap):

dwold_1-1721158617194.png

Text field is empty on survey:

dwold_4-1721158911489.png

@DougBrowning any tips on how to make this work?

Re: Use existing data in your survey - the pulldata( ) function

ChristopherCounsell — Tue, 16 Jul 2024 22:05:03 GMT

Excel files aren't supported it has to be a CSV.

Can you share the CSV files and xlsform? Usually these issues are tied to formatting of the CSV. Otherwise the screenshots look OK.

You also don't have to use underscores in select one. The S123 team have confirmed that it's ok to have some special characters including spaces for single choice. It's only multiple choice that has the no spaces requirement.

Re: Use existing data in your survey - the pulldata( ) function

dwold — Tue, 16 Jul 2024 23:35:23 GMT

@ChristopherCounsell coverting to csv worked. Thanks for the help, much appreciated!