topic if selected field starts with '' then other field = '', elif...? in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/if-selected-field-starts-with-then-other-field/m-p/842484#M21205 <HTML><HEAD></HEAD><BODY><P>Possible to do a compound if statement with starts with being the second argument? e.g.</P><P></P><P>If selected veg_field starts with 'A' then surface_field = 25, elif selected veg_field starts with 'B' then surface_field = 10 </P></BODY></HTML> Fri, 26 Jun 2020 04:16:15 GMT RichardWebb3 2020-06-26T04:16:15Z if selected field starts with '' then other field = '', elif...? https://community.esri.com/t5/arcgis-survey123-questions/if-selected-field-starts-with-then-other-field/m-p/842484#M21205 <HTML><HEAD></HEAD><BODY><P>Possible to do a compound if statement with starts with being the second argument? e.g.</P><P></P><P>If selected veg_field starts with 'A' then surface_field = 25, elif selected veg_field starts with 'B' then surface_field = 10 </P></BODY></HTML> Fri, 26 Jun 2020 04:16:15 GMT https://community.esri.com/t5/arcgis-survey123-questions/if-selected-field-starts-with-then-other-field/m-p/842484#M21205 RichardWebb3 2020-06-26T04:16:15Z Re: if selected field starts with '' then other field = '', elif...? https://community.esri.com/t5/arcgis-survey123-questions/if-selected-field-starts-with-then-other-field/m-p/842485#M21206 <HTML><HEAD></HEAD><BODY><P>Hi Richard</P><P></P><P>You could achieve this using the <STRONG>starts-with()</STRONG> function. The following example returns a number if veg_field starts with 'A' or 'B'; else it leaves the field blank:</P><P></P><PRE>if(starts-with(${veg_field},'A'),25,if(starts-with(${veg_field},'B'),10,''))</PRE><P><BR />For more on XLSForm functions and operators, please see:&nbsp;<A class="link-titled" href="https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm" title="https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm">Formulas—Survey123 for ArcGIS | Documentation</A>&nbsp;</P><P></P><P>Best,</P><P>Jim</P></BODY></HTML> Tue, 30 Jun 2020 03:05:22 GMT https://community.esri.com/t5/arcgis-survey123-questions/if-selected-field-starts-with-then-other-field/m-p/842485#M21206 Jim-Moore 2020-06-30T03:05:22Z