topic Re: CalculationMode in ArcGIS Survey123 Questions

CalculationMode

AdriannaBarton — Thu, 03 Mar 2022 00:10:29 GMT

With the new 3.14 release I have read that calculationMode is now a usable parameter. However, I cannot find any example documentation eanywhere on this , and after trying it in my forms it doe not appear to be working. In the esri::bind:parameters column I am putting: calculationMode=auto

Is that the correct syntax? What is the default calculationMode when no mode is entered?

Attached is the most detailed description I have found but no examples are included in that description.

Re: CalculationMode

Anonymous User — Thu, 03 Mar 2022 08:12:35 GMT

Hi @AdriannaBarton,

Documentation for calculationMode can be found here:

https://doc.arcgis.com/en/survey123/desktop/create-surveys/prepopulateanswers.htm#ESRI_SECTION1_FC295EA0A9354DCFA970B1D0B30D4DF4

Auto is the default when not specified. Using calculationMode=auto will not make any difference to not using it at all, as it will be same behavior in 3.13 and 3.14, where we auto applies rules to work out if the calculation should be run.

Always and manual will provide the additional functionality not possible before in 3.13.

Regards,

Phil.

Re: CalculationMode

AdriannaBarton — Thu, 03 Mar 2022 06:49:52 GMT

thank you for your response Phil. The link provided is not working:(

Re: CalculationMode

Anonymous User — Thu, 03 Mar 2022 08:13:37 GMT

Hi @AdriannaBarton.,

Sorry about that. I accidently pasted the dev link to our internal doc site. I have updated the link above to the public doc site.

Regards,

Phil.

Re: CalculationMode

AdriannaBarton — Thu, 03 Mar 2022 18:22:03 GMT

Thanks Phil!

Another question about these calculationModes- all of the documentation says these should only effect a recalcuations - so a calculation with the manual setting should be calculating once, correct? And only recalculating when the button is pressed?

I have a new issue within a repeat where I am creating a serial # for each repeat. This is how we have had it working perfectly before the update. It seems fine when I add 2+ repeats, but if I go back to the first repeat, the PHOTOS_Serial calculation is re-running, I put calculationMode=manual in the esri::bind:parameters for this fields and then it doesn't run whatsoever. I have attached the calculations I have and the fields. Please let me know why this isn't working. Thank you!

Re: CalculationMode

AdriannaBarton — Thu, 03 Mar 2022 18:30:01 GMT

Here is an image of what happens if I take 3 images and return to the first one. All of the serial #'s become the highest value.

Re: CalculationMode

Anonymous User — Thu, 03 Mar 2022 23:28:09 GMT

Hi @AdriannaBarton,

Thanks for pointing out the oversight in the documentation, we will have that fixed for the next update. The calculationMode actually applies to the first calculation, as well as subsequent recalculations. Therefore if you use manual, no calculation will be run the first time, until the button is pressed. The explanation of this was correct in the blog post, just not in the online documentation:

What's new in ArcGIS Survey123 (February 2022) - Esri Community

As for the issue you are seeing with your sum() calculation in the repeat, this is expected. It actually was not working correctly before, and values were not being updated when they should have been in 3.13 or earlier, a bug we fixed.

If you use a reference in a calculation to a field inside the same repeat, for a value that comes from the repeat or other records in that same repeat, the sum() will update after new values are added to other records. The best way to do what you are wanting, it to use position(..) and/or indexed-repeat() functions, to ensure the value is only updated once and for that current repeat record you are on. You can also use the once() function in combination to ensure it only runs once also. See below documentation:

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformrepeats.htm#ESRI_SECTION1_9F07ECB9F1C341CF8A05AF54B1B011B0

If you search the forums there are many users also doing something similar to what you are after, and have successfully used position(..), indexed-repeat() and once() to achieve this across repeats.

Regards,

Phil.

Re: CalculationMode

AdriannaBarton — Fri, 04 Mar 2022 19:45:28 GMT

Thank you Phil! The position(..) worked like a charm. I appreciate the help!