Need help with pulldata function

Question

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?

Jim Moore · Accepted Answer

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