I feel like I am always trying to push the limitations of Survey123, what a fun time. Anyways, I have created a Survey form for recording Water Breaks (Leaks). I have used "Constraints" to allow certain variables for the calculations I need to appear based on the type of water break (hole, rectangular, circular are my 3 options). So if the field worker clicks rectangular break, then they will have the option to enter in the length, width etc.. needed to perform the calculcation.
I have one field for the "Area" of the water leak break needed for me to do calculate water loss. All 3 water break types share this value, but use different calculations to achieve this value. Is there a way I can put multiple equations in the field but only using the desired equation (say IF "Rectangular_Break" is chosen use this equation OR IF "Circular_Break" is chosen use this equation.
My only thought, which is not ideal, but is it use multiple "Area" fields based on the break type, but then for my next calculations I would have to make multiple "Water loss calculations" etc.. based on the break type. If that makes sense. I was thinking if Repeats or IF statement etc.. can be used with calculations could create a work around?
Thank you all, if you need anything to help figure out what I am trying to achieve please comment. I am attaching the water breaks equations that I am basing my survey123 off of (you can see they share variables etc..). I can share my survey too but would prefer to DM. Appreciate it!
Solved! Go to Solution.
The If function worked great, I couldn't get the Coalesce to work with my calculation for some reason (probably did something wrong, will probably try that again separately just for fun).
Thanks for everything you and James Tedrick do; really been liking incorporating Survey123 with Collector