Hello, we we are currently using survey123 for collecting field data on aquatic organism passage barriers in the field. Our survey is set up with a repeat that equates to a table relate for each pipe at a road stream crossing. once data is collected, we must export the data and bring it into excel to do some logistical excel if/then calculations and then some equations to get a final barrier score. my question is, how complicated can I get in the calculate field for xls forms? I can’t seem to find anything more complicated that someone has done other than adding a tip to a bill. Can I use if/then in xls forms? If this possible it would be a huge breakthrough for us! TIA!
From the sounds of it, you should be able to accomplish this within the form. There is an if() function, which works in the same way as if() works in Excel; additionally, there is a core set of mathematical functions that include exponential, logarithmic and trigonometric functions.
For more information on the functions supported, take a look at Formulas—Survey123 for ArcGIS | ArcGIS, https://community.esri.com/groups/survey123/blog/2016/09/06/new-mathematical-functions-make-your-for... .