topic Relevant Formula Help in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/relevant-formula-help/m-p/764041#M2001 <HTML><HEAD></HEAD><BODY><P>I'm trying to accomplish three things in my survey:</P><P></P><OL><LI>Have the survey taker choose from a list of names (their own) - I understand how to do this part!</LI><LI>Once the user chooses their name, a list of project names are presented for them to choose from that are unique to them.</LI><LI>After the user chooses their project name, a simple yes or no choice will be presented to them to choose from; perhaps to indicate whether they completed it or not.</LI></OL><P></P><P>I believe I need to use a relevant formula to accomplish #2 but I am not sure how to set up the formula so it's choosing from the previous step NAME. For instance, I can use <SPAN style="color: #2873ee;">selected(${NAME}, 'John Doe')</SPAN> but the John Doe name may change depending on the user taking the survey. How would I accommodate this selection?</P><P></P><P>Thank you for your help!</P></BODY></HTML> Mon, 04 Apr 2016 18:58:03 GMT JaromHlebasko 2016-04-04T18:58:03Z Relevant Formula Help https://community.esri.com/t5/arcgis-survey123-questions/relevant-formula-help/m-p/764041#M2001 <HTML><HEAD></HEAD><BODY><P>I'm trying to accomplish three things in my survey:</P><P></P><OL><LI>Have the survey taker choose from a list of names (their own) - I understand how to do this part!</LI><LI>Once the user chooses their name, a list of project names are presented for them to choose from that are unique to them.</LI><LI>After the user chooses their project name, a simple yes or no choice will be presented to them to choose from; perhaps to indicate whether they completed it or not.</LI></OL><P></P><P>I believe I need to use a relevant formula to accomplish #2 but I am not sure how to set up the formula so it's choosing from the previous step NAME. For instance, I can use <SPAN style="color: #2873ee;">selected(${NAME}, 'John Doe')</SPAN> but the John Doe name may change depending on the user taking the survey. How would I accommodate this selection?</P><P></P><P>Thank you for your help!</P></BODY></HTML> Mon, 04 Apr 2016 18:58:03 GMT https://community.esri.com/t5/arcgis-survey123-questions/relevant-formula-help/m-p/764041#M2001 JaromHlebasko 2016-04-04T18:58:03Z Re: Relevant Formula Help https://community.esri.com/t5/arcgis-survey123-questions/relevant-formula-help/m-p/764042#M2002 <HTML><HEAD></HEAD><BODY><P>Cascading select should work. Check this out <A href="https://community.esri.com/migration-blogpost/55215">Cascading Selects and External Selects</A>&nbsp; and see if it helps.</P><P>--gary</P></BODY></HTML> Mon, 04 Apr 2016 20:24:28 GMT https://community.esri.com/t5/arcgis-survey123-questions/relevant-formula-help/m-p/764042#M2002 GaryBowles1 2016-04-04T20:24:28Z