topic Survey123 Populate a cell based on a previous choices list. in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/survey123-populate-a-cell-based-on-a-previous/m-p/866792#M27190 <HTML><HEAD></HEAD><BODY><P>Hey Gang,</P><P></P><P>In a column, I have a select_one function from a choices list of 45 string values. I am trying to populate a cell with an integer value based on this first choice. from a second choices list.</P><P></P><P>The first Choice list looks like this;</P><P></P><TABLE width="565"><TBODY><TR><TD width="94">Lot</TD><TD width="222">Acadia Street West (6)</TD><TD width="249">Acadia Street West (6) - 12</TD></TR></TBODY></TABLE><P></P><P>The second choice list looks like this;</P><P></P><TABLE width="565"><TBODY><TR><TD width="94">Lotn</TD><TD width="222">Acadia Street West (6) - 12</TD><TD width="249"><P>12</P><P></P></TD></TR></TBODY></TABLE><P><BR />I can build out a series of If statements (45 in Total), but just wondering if I can populate the second field with an integer from the second choice, based on what I chose from the first Choice List.</P><P></P><P>Hope this makes sense.</P><P></P><P>T.</P></BODY></HTML> Tue, 18 Feb 2020 18:36:03 GMT TrevorRobar2 2020-02-18T18:36:03Z Survey123 Populate a cell based on a previous choices list. https://community.esri.com/t5/arcgis-survey123-questions/survey123-populate-a-cell-based-on-a-previous/m-p/866792#M27190 <HTML><HEAD></HEAD><BODY><P>Hey Gang,</P><P></P><P>In a column, I have a select_one function from a choices list of 45 string values. I am trying to populate a cell with an integer value based on this first choice. from a second choices list.</P><P></P><P>The first Choice list looks like this;</P><P></P><TABLE width="565"><TBODY><TR><TD width="94">Lot</TD><TD width="222">Acadia Street West (6)</TD><TD width="249">Acadia Street West (6) - 12</TD></TR></TBODY></TABLE><P></P><P>The second choice list looks like this;</P><P></P><TABLE width="565"><TBODY><TR><TD width="94">Lotn</TD><TD width="222">Acadia Street West (6) - 12</TD><TD width="249"><P>12</P><P></P></TD></TR></TBODY></TABLE><P><BR />I can build out a series of If statements (45 in Total), but just wondering if I can populate the second field with an integer from the second choice, based on what I chose from the first Choice List.</P><P></P><P>Hope this makes sense.</P><P></P><P>T.</P></BODY></HTML> Tue, 18 Feb 2020 18:36:03 GMT https://community.esri.com/t5/arcgis-survey123-questions/survey123-populate-a-cell-based-on-a-previous/m-p/866792#M27190 TrevorRobar2 2020-02-18T18:36:03Z Re: Survey123 Populate a cell based on a previous choices list. https://community.esri.com/t5/arcgis-survey123-questions/survey123-populate-a-cell-based-on-a-previous/m-p/866793#M27191 <HTML><HEAD></HEAD><BODY><P>Hi Trevor,</P><P></P><P>Typically, you would use the integer value as the name value of the list, which would get you the value directly.</P></BODY></HTML> Wed, 19 Feb 2020 21:33:06 GMT https://community.esri.com/t5/arcgis-survey123-questions/survey123-populate-a-cell-based-on-a-previous/m-p/866793#M27191 JamesTedrick 2020-02-19T21:33:06Z