topic Re: Trigger calculations when coded domain selected by user in ArcGIS Survey123 Questions

Trigger calculations when coded domain selected by user

Anonymous User — Sun, 12 Dec 2021 10:51:36 GMT

Hi all,

I am creating a form and have a field with the following coded values:

0     
1     Circular
2     Arch
3     Square
4     Open Square
5     Open Arch
‍‍‍‍‍‍

Each of those coded values should have a calculation associated with it. for instance, if user selects "Circular" then survey123 would automatically trigger the following equation (knowing that we have some of the variables in other fields):

V=πr2h‍

Is it possible in survey 123?

Thanks,

Alex

Re: Trigger calculations when coded domain selected by user

JamesTedrick — Tue, 02 May 2017 23:11:06 GMT

Hi Alex,

There are a couple of ways, depending on how you plan to store the results of the calculation. If they can be in separate fields, you can make a question for each formula that has a relevant statement set to only present the question with the proper choice selected. If they need to be stored in the same field, you would use a series of nested if() functions to check which value is selected and then execute the appropriate function.

Re: Trigger calculations when coded domain selected by user

Anonymous User — Sun, 12 Dec 2021 10:51:39 GMT

I would rather have the second option in my form. Where would I plug in these nested if() in my form? And would it be something like (in python? in the follwing example I am using JS):

if (${SW_TYPE_SHAPE} = "codedvalue"){
code goes here
}
else if(${SW_TYPE_SHAPE} = "codedvalue"){
code goes here
}‍‍‍‍‍‍‍‍‍‍‍‍

Re: Trigger calculations when coded domain selected by user

JamesTedrick — Wed, 03 May 2017 00:39:19 GMT

Hi Alex,

This would be placed in the calculation column and would actually be more like how Excel specifies this (nested evaluators):

if(${SW_TYPE_SHAPE} = "1", <function1>, if(${SW_TYPE_SHAPE} = "2", <function2>, ...))

Re: Trigger calculations when coded domain selected by user

Anonymous User — Wed, 03 May 2017 21:42:09 GMT

It seems like Excel does not like the $ . What am I doing wrong here?

Re: Trigger calculations when coded domain selected by user

JamesTedrick — Wed, 03 May 2017 22:01:34 GMT

Don't use an equal sign (=) that is asking Excel to do the calculation, not Survey123.

Re: Trigger calculations when coded domain selected by user

Anonymous User — Thu, 04 May 2017 15:37:28 GMT

One last thing. Sorry I am not familiar with this. I get that error

When entering the formula this way: if(${SW_TYPE_SHAPE} = "1", <function1>, if(${SW_TYPE_SHAPE} = "2", <function2>, ...))

It seems like it cannot navigate to the "choices" sheet. I am not too sure how to reference that SW_TYPE_SHAPE.

Thanks,

Alex

Re: Trigger calculations when coded domain selected by user

IsmaelChivite — Thu, 04 May 2017 15:48:05 GMT

The string within the curly brackets references an existing question within your form. Simply put the NAME of the question in your form that holds the values for the shape type and you should be good. The error you are getting indicates that your formula is referencing a question named SW_TYPE_SHAPE, which is not present in your XLSfile. Please note that questions are referenced through the value in the NAME column, not the LABEL.

These links show in more detail how to use formulas in Survey123

https://community.esri.com/groups/survey123/blog/2016/09/06/new-mathematical-functions-make-your-form-smarter

Formulas—Survey123 for ArcGIS | ArcGIS

The Calculations sample form is also a good reference to get started with expressions in Survey123. You can create a dummy form using this sample and then look at the XLSFile to learn the syntax

Re: Trigger calculations when coded domain selected by user

JamesTedrick — Thu, 04 May 2017 15:49:26 GMT

Hi Alex,

Without seeing your Excel sheet, I can't be certain. The cropped image provided above does not have a question named SW_TYPE_SHAPE, and the labels don't distinguish which question is which. What is the name of the question with values you are evaluating (I was simply copying from what you provided as an example)?

Re: Trigger calculations when coded domain selected by user

Anonymous User — Thu, 04 May 2017 16:49:51 GMT

Thanks Ismael for the good calculation samples you provided. That will be very useful.

James, Thank you for your help. I was not referencing the domain choice name not the actual form question. The issue is solved. I can now enter the formulas in nested IF statements. Great product by the way.