Instead of pull data from CSV, can Survey123 pull data from the geodb it's connected to?

HenryWangSP

If I configure my Survey123 to connect to our geodatabase, some of the field values need to be pulled externally, and they are dynamic and subject to change overtime. I know I can pull external data from CSV files and need to keep the CSV files updated.

But it would be easier to actually pull data from the source data tables in the underlying geodb instead of keeping the CSV files in-sync with the source data.

Move over, updating data and keeping data integrity is easier in geodatabase, and some more complex logics can also be applied on top of those data. 

So is connecting/pulldata from geodb supported?  

ChristopherCounsell

Semantics, but Survey123 doesn't connect to geodatabases. It targets feature services. Assuming your survey is targeting an ArcGIS Server feature service pointing at the geodatabase.

You can use the pulldata(@layer) function to pull data from the service layer. It can be the same as the target layer or a different one.

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

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-pulldata-quot-layer/ba-p/1224415

You'll need to adapt the lookup formula to a layer query.

Also note the limitations in the function, like it doesn't work offline as it needs a live connection to the db.