Need help with pulldata function

JerryAckerman — Wed, 15 Apr 2020 15:18:50 GMT

I'm working on a survey and would like to have the dissolved oxygen value (eg. 8.29) autopopulate by entering the barometric pressure and the temperature in separate fields. Can this be accomplished in Survey123?

Re: Need help with pulldata function

Jim-Moore — Sun, 12 Dec 2021 16:53:42 GMT

Hi Jerry

Yes this is possible using pulldata() to look up the value from a CSV file. Say you have a CSV file named solubility.csv that looks something like this:

temp,baro700,baro701,baro702
20.0,8.36,8.37,8.38
20.1,8.34,8.35,8.37
20.2,8.32,8.34,8.35
(etc.)

And the user enters values into ${temp} and ${pressure} questions, you could then use a calculation similar to this to retrieve the value:

pulldata('solubility',concat('baro',${pressure}),'temp',${temp})

Plenty of great info on pulldata in this blog: https://community.esri.com/groups/survey123/blog/2016/10/27/the-pulldata-function-access-external-data

And also documented here: Formulas—Survey123 for ArcGIS | Documentation

Hope this helps.

Best,

Jim

topic Need help with pulldata function in ArcGIS Survey123 Questions

Need help with pulldata function

Re: Need help with pulldata function