topic Cascading Select and External Select in ArcGIS Connect in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/cascading-select-and-external-select-in-arcgis/m-p/882644#M30992 <HTML><HEAD></HEAD><BODY><P>Hi All! I want to design a survey form for internal use in my organization in which has a requirement select district, county and village from a drop down combo box. I want to use an External select feature of the Excel file since there could be close to a 1000 villages in each county. Each village has a village code which uniquely identifies the village as opposed to names. I want to use names for the villages but once the user selects a village by name from the list of villages, both the name as well as the underlying village code should be stored in the Excel file.</P><P>I have found resources many resources on cascading select but no good ones explaining how the External Select works.</P><P>Can anyone guide me please?</P><P>Thank a lot!</P></BODY></HTML> Wed, 31 Jan 2018 11:36:33 GMT ManeeshMassey 2018-01-31T11:36:33Z Cascading Select and External Select in ArcGIS Connect https://community.esri.com/t5/arcgis-survey123-questions/cascading-select-and-external-select-in-arcgis/m-p/882644#M30992 <HTML><HEAD></HEAD><BODY><P>Hi All! I want to design a survey form for internal use in my organization in which has a requirement select district, county and village from a drop down combo box. I want to use an External select feature of the Excel file since there could be close to a 1000 villages in each county. Each village has a village code which uniquely identifies the village as opposed to names. I want to use names for the villages but once the user selects a village by name from the list of villages, both the name as well as the underlying village code should be stored in the Excel file.</P><P>I have found resources many resources on cascading select but no good ones explaining how the External Select works.</P><P>Can anyone guide me please?</P><P>Thank a lot!</P></BODY></HTML> Wed, 31 Jan 2018 11:36:33 GMT https://community.esri.com/t5/arcgis-survey123-questions/cascading-select-and-external-select-in-arcgis/m-p/882644#M30992 ManeeshMassey 2018-01-31T11:36:33Z Re: Cascading Select and External Select in ArcGIS Connect https://community.esri.com/t5/arcgis-survey123-questions/cascading-select-and-external-select-in-arcgis/m-p/882645#M30993 <HTML><HEAD></HEAD><BODY><P>Hi Maneesh,</P><P></P><P>You'll find the documentation for external selects at&nbsp;<A class="link-titled" href="http://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformcascadingselects.htm" title="http://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformcascadingselects.htm">Cascading and external selects—Survey123 for ArcGIS | ArcGIS</A>&nbsp;. You will need to create a new worksheet in the XLS file called external_choice - it will have the same structure as the choices worksheet. &nbsp;When processing the form, this worksheet becomes a csv file named itemsets.csv.</P><P></P><P>The one issue presented by what you're trying to do is the capture of the name as well as the code. &nbsp;This can be done by using the pulldata function on the itemsets file, though this can be break if you are using multiple languages in your choices.&nbsp;</P></BODY></HTML> Wed, 31 Jan 2018 17:32:16 GMT https://community.esri.com/t5/arcgis-survey123-questions/cascading-select-and-external-select-in-arcgis/m-p/882645#M30993 JamesTedrick 2018-01-31T17:32:16Z