Need help with pulldata function

[JerryAckerman]

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 solution]

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-da... 

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

Hope this helps.

Best,

Jim