nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Trigger calculations when coded domain selected by user

Anonymous User

Hi all,

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

0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Circular
2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Arch
3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Square
4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Open Square
5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Open Arch
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

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<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Is it possible in survey 123?

Thanks,

Alex

Najděte více příspěvků označených jako

Accepted answers

JamesTedrick

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>, ...))

All comments

JamesTedrick

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.

Anonymous User

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
}‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JamesTedrick

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>, ...))

Anonymous User

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

JamesTedrick

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

Anonymous User

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

IsmaelChivite

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

JamesTedrick

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)?

Anonymous User

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.

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.