Possible to do a compound if statement with starts with being the second argument? e.g.
If selected veg_field starts with 'A' then surface_field = 25, elif selected veg_field starts with 'B' then surface_field = 10
Solved! Go to Solution.
Hi Richard
You could achieve this using the starts-with() function. The following example returns a number if veg_field starts with 'A' or 'B'; else it leaves the field blank:
if(starts-with(${veg_field},'A'),25,if(starts-with(${veg_field},'B'),10,''))
For more on XLSForm functions and operators, please see: Formulas—Survey123 for ArcGIS | Documentation
Best,
Jim
Hi Richard
You could achieve this using the starts-with() function. The following example returns a number if veg_field starts with 'A' or 'B'; else it leaves the field blank:
if(starts-with(${veg_field},'A'),25,if(starts-with(${veg_field},'B'),10,''))
For more on XLSForm functions and operators, please see: Formulas—Survey123 for ArcGIS | Documentation
Best,
Jim