# Need help with pulldata function

149
1
04-15-2020 08:18 AM
New Contributor

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?

1 Solution

Accepted Solutions
Esri Regular Contributor

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

Esri Regular Contributor

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