topic Re: pulldata function not working for me in ArcGIS Survey123 Questions

pulldata function not working for me

JGVadnais1 — Mon, 07 Mar 2022 19:57:19 GMT

I'm creating a survey that populates the FIPS code for a selected California Mission. Unfortunately, It's not working. I've tried to troubleshoot on my own without any luck. Hoping the community could provide insight. Thank you!

Attachments:

The Survey123 connect form labeled California Missions 2

The CSV file labeled calmissions1

Re: pulldata function not working for me

DougBrowning — Mon, 07 Mar 2022 20:25:23 GMT

Try without the commas. It is a CSV so commas can get you.

Re: pulldata function not working for me

DominicRobergeIADOT — Mon, 07 Mar 2022 20:37:45 GMT

Should the value in your CSV (field names) be the same as your list_missions that you are using for your field Missions?

Re: pulldata function not working for me

JGVadnais1 — Mon, 07 Mar 2022 21:13:32 GMT

Great catch! Thank you.
I have another question. After updating the survey, the pulldata function worked - as shown in the image.

Now, I'm learning that I cannot update calculations. Is this because I initial created the survey in the online web app version? In order to use the pulldata function, do I have to create the survey in connect?

Re: pulldata function not working for me

DominicRobergeIADOT — Mon, 07 Mar 2022 21:34:35 GMT

Glad it solved your first problem (please mark as the accepted solution).

I am not a Surver123 export but yes I do believe that you have to publish the from Survey Connect

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_A3C2F3566F974734B55ECECD31C6CA91