topic Hello Everyone. I am working on a form that has to auto populate fields using information in a feature layer with multiple data table. I need help in accessing the tables to extract the information for my survey. in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/hello-everyone-i-am-working-on-a-form-that-has-to/m-p/811763#M13489 <HTML><HEAD></HEAD><BODY><P>I got 4 tables on a feature layer. one of the tables has contains info about our staff members. we want o get that information when you select a staff member name and loud all there their information.&nbsp;&nbsp;</P></BODY></HTML> Mon, 31 Aug 2020 05:42:41 GMT KholofeloMakwela 2020-08-31T05:42:41Z Hello Everyone. I am working on a form that has to auto populate fields using information in a feature layer with multiple data table. I need help in accessing the tables to extract the information for my survey. https://community.esri.com/t5/arcgis-survey123-questions/hello-everyone-i-am-working-on-a-form-that-has-to/m-p/811763#M13489 <HTML><HEAD></HEAD><BODY><P>I got 4 tables on a feature layer. one of the tables has contains info about our staff members. we want o get that information when you select a staff member name and loud all there their information.&nbsp;&nbsp;</P></BODY></HTML> Mon, 31 Aug 2020 05:42:41 GMT https://community.esri.com/t5/arcgis-survey123-questions/hello-everyone-i-am-working-on-a-form-that-has-to/m-p/811763#M13489 KholofeloMakwela 2020-08-31T05:42:41Z Re: Hello Everyone. I am working on a form that has to auto populate fields using information in a feature layer with multiple data table. I need help in accessing the tables to extract the information for my survey. https://community.esri.com/t5/arcgis-survey123-questions/hello-everyone-i-am-working-on-a-form-that-has-to/m-p/811764#M13490 <HTML><HEAD></HEAD><BODY><P>Hi Kholofelo,</P><P></P><P>There are 2 ways you could look into doing this:</P><P>- Save the data as CSV files with the form and use the pulldata() function to lookup the information. &nbsp;See&nbsp;<A class="link-titled" href="https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_A3C2F3566F974734B55ECECD31C6CA91" title="https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_A3C2F3566F974734B55ECECD31C6CA91">Formulas—ArcGIS Survey123 | Documentation</A>&nbsp;for more information</P><P>- Create a custom JavaScript function that retrieves the data directly from the feature service. &nbsp;See&nbsp;<A class="link-titled" href="https://doc.arcgis.com/en/survey123/desktop/create-surveys/pulldatajavascript.htm" title="https://doc.arcgis.com/en/survey123/desktop/create-surveys/pulldatajavascript.htm">JavaScript functions in survey forms—ArcGIS Survey123 | Documentation</A>&nbsp;for more information.</P><P></P><P>Both of these approaches also have samples in the Survey123 Connect Samples gallery.</P></BODY></HTML> Mon, 31 Aug 2020 18:37:49 GMT https://community.esri.com/t5/arcgis-survey123-questions/hello-everyone-i-am-working-on-a-form-that-has-to/m-p/811764#M13490 JamesTedrick 2020-08-31T18:37:49Z