topic Re: How can I give the user different list based on the answers to previous questions? in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/how-can-i-give-the-user-different-list-based-on/m-p/881981#M30828 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>One way to consolidate the answers of the questions would be to set&nbsp;the select_multiple questions' bind:Esri:fieldType values to null and have a calculate question (let's call it photo_label) that uses the coalesce() function to get the answer from the 1 of the 4 that is not null:</P><P></P><P>coalesce(${BridgeNS},<SPAN>coalesce(${BridgeEW},coalesce(${CulverNS},${CulvertEW}))</SPAN>)</P></BODY></HTML> Fri, 21 Feb 2020 20:50:43 GMT JamesTedrick 2020-02-21T20:50:43Z How can I give the user different list based on the answers to previous questions? https://community.esri.com/t5/arcgis-survey123-questions/how-can-i-give-the-user-different-list-based-on/m-p/881978#M30825 <HTML><HEAD></HEAD><BODY><P>I am trying to create a structure inspection survey. The inspector takes specific photos based on the structure type and orientation.</P><P>The user will select a structure type (Bridge/Culvert), then will select the orientation(NorthSouth/EastWest). Based on these two answers, there will be four different results and 4 different captions/checklist for photos. The number of photos to be taken can be different based on the answers. The result of each survey should be the same as the excel sheet.</P></BODY></HTML> Tue, 18 Feb 2020 17:01:28 GMT https://community.esri.com/t5/arcgis-survey123-questions/how-can-i-give-the-user-different-list-based-on/m-p/881978#M30825 Anonymous User 2020-02-18T17:01:28Z Re: How can I give the user different list based on the answers to previous questions? https://community.esri.com/t5/arcgis-survey123-questions/how-can-i-give-the-user-different-list-based-on/m-p/881979#M30826 <HTML><HEAD></HEAD><BODY><P>Hi Caner,</P><P></P><P>In looking at your sheet, I see only the photos for the Bridge &amp; NorthSouth selections. &nbsp;Do you have a list for all 4 combinations (Bridge vs Culvert and NorthSouth vs EastWest)?</P><P></P><P>In general, you can create an image question for each photo you would require on the form and have it hide/show using a relevant statement. &nbsp;See&nbsp;<A href="https://community.esri.com/groups/survey123/blog/2015/08/24/using-formulas-in-survey123">https://community.esri.com/groups/survey123/blog/2015/08/24/using-formulas-in-survey123</A>&nbsp;and&nbsp;<A class="link-titled" href="https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformexpressions.htm" title="https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformexpressions.htm">Form expressions—Survey123 for ArcGIS | Documentation</A>&nbsp;for more details.</P></BODY></HTML> Tue, 18 Feb 2020 21:50:25 GMT https://community.esri.com/t5/arcgis-survey123-questions/how-can-i-give-the-user-different-list-based-on/m-p/881979#M30826 JamesTedrick 2020-02-18T21:50:25Z Re: How can I give the user different list based on the answers to previous questions? https://community.esri.com/t5/arcgis-survey123-questions/how-can-i-give-the-user-different-list-based-on/m-p/881980#M30827 <HTML><HEAD></HEAD><BODY><P>I have used this way but it creates 4 different fields. Is there any way to make Survey123 pick one of the list options based on the previous selections? I attached the template to the question.</P><P><IMG alt="Select list" class="jive-emoji image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/482632_Capture.JPG" /></P></BODY></HTML> Wed, 19 Feb 2020 13:34:34 GMT https://community.esri.com/t5/arcgis-survey123-questions/how-can-i-give-the-user-different-list-based-on/m-p/881980#M30827 Anonymous User 2020-02-19T13:34:34Z Re: How can I give the user different list based on the answers to previous questions? https://community.esri.com/t5/arcgis-survey123-questions/how-can-i-give-the-user-different-list-based-on/m-p/881981#M30828 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>One way to consolidate the answers of the questions would be to set&nbsp;the select_multiple questions' bind:Esri:fieldType values to null and have a calculate question (let's call it photo_label) that uses the coalesce() function to get the answer from the 1 of the 4 that is not null:</P><P></P><P>coalesce(${BridgeNS},<SPAN>coalesce(${BridgeEW},coalesce(${CulverNS},${CulvertEW}))</SPAN>)</P></BODY></HTML> Fri, 21 Feb 2020 20:50:43 GMT https://community.esri.com/t5/arcgis-survey123-questions/how-can-i-give-the-user-different-list-based-on/m-p/881981#M30828 JamesTedrick 2020-02-21T20:50:43Z