Complicated calculations in xls forms for Survey123?

128
1
05-04-2018 09:54 AM
Highlighted
New Contributor III

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!

1 Reply
Highlighted
Esri Esteemed Contributor

Hi Kathleen,

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 | ArcGIShttps://community.esri.com/groups/survey123/blog/2016/09/06/new-mathematical-functions-make-your-for...  .