https://community.esri.com/t5/arcgis-survey123-questions/instead-of-pull-data-from-csv-can-survey123-pull/m-p/1352332#M53005 <P>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.</P><P>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.</P><P><A href="https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_BB97985CAFB740EE8AEF99EFD6E238E3" target="_blank">https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_BB97985CAFB740EE8AEF99EFD6E238E3</A></P><P><A href="https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-pulldata-quot-layer/ba-p/1224415" target="_blank">https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-pulldata-quot-layer/ba-p/1224415</A></P><P>You'll need to adapt the lookup formula to a layer query.</P><P>Also note the limitations in the function, like it doesn't work offline as it needs a live connection to the db.</P> Tue, 21 Nov 2023 22:42:32 GMT ChristopherCounsell 2023-11-21T22:42:32Z https://community.esri.com/t5/arcgis-survey123-questions/instead-of-pull-data-from-csv-can-survey123-pull/m-p/1352303#M53003 <P>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.</P><P>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.</P><P>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.&nbsp;</P><P>So is connecting/pulldata from geodb supported?&nbsp;&nbsp;</P> Tue, 21 Nov 2023 21:55:05 GMT https://community.esri.com/t5/arcgis-survey123-questions/instead-of-pull-data-from-csv-can-survey123-pull/m-p/1352303#M53003 HenryWangSP 2023-11-21T21:55:05Z https://community.esri.com/t5/arcgis-survey123-questions/instead-of-pull-data-from-csv-can-survey123-pull/m-p/1352332#M53005 <P>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.</P><P>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.</P><P><A href="https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_BB97985CAFB740EE8AEF99EFD6E238E3" target="_blank">https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_BB97985CAFB740EE8AEF99EFD6E238E3</A></P><P><A href="https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-pulldata-quot-layer/ba-p/1224415" target="_blank">https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-pulldata-quot-layer/ba-p/1224415</A></P><P>You'll need to adapt the lookup formula to a layer query.</P><P>Also note the limitations in the function, like it doesn't work offline as it needs a live connection to the db.</P> Tue, 21 Nov 2023 22:42:32 GMT https://community.esri.com/t5/arcgis-survey123-questions/instead-of-pull-data-from-csv-can-survey123-pull/m-p/1352332#M53005 ChristopherCounsell 2023-11-21T22:42:32Z