Community
Select to view content in your preferred language

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

487
1
11-21-2023 01:55 PM
HenryWangSP
by
New Contributor
‎11-21-2023 01:55 PM

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?  

0 Kudos
1 Reply
ChristopherCounsell
by MVP Regular Contributor
MVP Regular Contributor
‎11-21-2023 02:42 PM

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

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-pulldata-quot-laye...

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.