topic Re: If statement calculation, Survey123 in ArcGIS Survey123 Questions

If statement calculation, Survey123

KatieWise — Mon, 05 Mar 2018 18:57:04 GMT

I am working on creating form with multiple repeats/questions. What I am trying to do is calculate an answer to a question based on the which answer was chosen from the previous select_one question. I will use sample data for simplicity sake.

select_one color: green, blue, red, yellow

calculation results based on color chosen (what I am trying): if(selected(${color}, 'red', 'Cardinal', if(selected(${color}, 'green', 'Parrot', if(selected(${color}, 'blue', 'Bluebird', if(selected(${color}, 'yellow', 'Finich', 'N/A'))))))))

I have received multiple different errors for trying this multiple ways, the current error is "requires 3 arguments, only provided 1"...Sometimes I get "requires 3 arguments, only provided 4 or 5 etc"

What am I doing incorrectly?

Re: If statement calculation, Survey123

KatieWise — Mon, 05 Mar 2018 20:34:28 GMT

I figured it out, took the "selected" out and eventually got everything correct.

Re: If statement calculation, Survey123

Anonymous User — Wed, 07 Mar 2018 04:30:40 GMT

Hi Mary,

Glad you got it working. The reason your calculation was not working is that you are missing closing brackets on your selected statement. It should be similar to: selected(${question},'answer').

Therefore using a selected statement in an if statement: if(selected(${question},'answer'),'true','false')

And you can then nest the if statements as you have done in your original calculation.

You can find some good info in this blog: https://community.esri.com/groups/survey123/blog/2016/05/28/the-art-of-hiding

Phil.

Re: If statement calculation, Survey123

ShawnRoberts1 — Thu, 05 Jul 2018 14:26:54 GMT

Hi All, I believe I'm attempting to do the same thing however I'm fighting the syntax and was hoping for assistance.

Essentially a pre selected culvert type determines the expression used to calculate a value. So it I select culvert type A do this math, if I select culvert type B do different math ect with culvert types C,D,E,F

So far I have (if culvert type CSP is selected the math is just the IS rating * 2.

if((selected(${CulvertType},'C.S.P'),int(${InvertSedimentRating}*2),0))

But I'm struggling to get more values in for the selected (the below line doesn't work can't figure out why)

if(selected(${CulvertType},'C.S.P'),int(${InvertSedimentRating}*2),0),if(selected(${CulvertType},'H.D.P.E'),int(${InvertSedimentRating}*3.2),0)

Any advice?

Re: If statement calculation, Survey123

NickDierks1 — Thu, 05 Jul 2018 15:38:49 GMT

The way the statement is written, your first else case is 0, when it needs to be the next if() statement. Basically, it reads as:

if culvert type is CSP

then int(${InvertSedimentRating}*2

else 0

----- the function stops here, because that is a full statement. Anything else after this in the same calculation either isn't evaluated or just plain breaks.

In order to nest your if() statements, the next if() needs to take the place of the preceding if()'s else case. Simply remove the "0)," from the first if() in your calculation, and close up the parentheses at the end:

if(selected(${CulvertType},'C.S.P'),int(${InvertSedimentRating}*2),if(selected(${CulvertType},'H.D.P.E'),int(${InvertSedimentRating}*3.2),0))

if culvert type is CSP

then int(${InvertSedimentRating}*2

else if culvert type is HDPE

then int(${InvertSedimentRating}*3.2

else 0

Re: If statement calculation, Survey123

ShawnRoberts1 — Thu, 05 Jul 2018 15:41:22 GMT

Perfect thanks Nick!

Re: If statement calculation, Survey123

ReneAubut — Thu, 26 Jul 2018 20:14:50 GMT

Hi,

I included an integer type question for getting the number of truck axles (truck_axles: from 2 to 8), and a decimal type question for getting the truck load percentage(load_pct). Each truck axle value has a theoretical load capacity (theo_load_weight). In my calculation to get the effective weight (load_weight), I must match the theoretical load capacity, from the axles number, and then multiply by the load percentage

Not sure if I should use an IF

if(selected(${truck_axles},'2'),...?

Re: If statement calculation, Survey123

JamesTedrick — Wed, 01 Aug 2018 23:10:36 GMT

Hi Rene,

An if() statement sequence may work for what you are doing. An alternative would be to have the theo_load_weight data in a CSV and use pulldata() to look up the value based on the number of axles. See Formulas—Survey123 for ArcGIS | ArcGIS for more information on pulldata().

Re: If statement calculation, Survey123

ReneAubut — Fri, 08 Mar 2019 19:34:34 GMT

Hello, I have 4 types of truck monitoring (Type_Suivi): ImportationREM, Reutilisation, Elimination and Entreposage. For question WBS_Origine, i set a relevant condition where truck monitoring is ImportationREM, but then for that same question, i use this statement in the calculation cell.:

if (selected(${Type_Suivi},'Elimination'),${WBS_id},if(selected(${Type_Suivi},'Reutilisation'),${WBS_id},if (selected(${Type_Suivi},'Entreposage'),${WBS_id},’0’)))

Doing so, all questions after that one are omitted. Is the relevant condition blocking the calculation and everthing else that follows?

WBS_id is a text variable for storing coded areas of the project site that am attempting to write to the WBS_Origine

Thanks

Re: If statement calculation, Survey123

MichaelFazio2 — Mon, 01 Apr 2019 20:54:17 GMT

Hello, I have a survey for collecting water data, and want to symbolize the map based off of collected values. I figured using a calculation field in the survey would be a good work around, as I could just based the symbology off that field. Basically I need to know if the water is "Oligotrophic", "Mesotrophic", or "Eutrophic" based on the following values:

Can anybody provide any suggestions. I'm pretty new to Survey123, and the calculation I am trying to use is long and likely erroneous:

if(${P}<15,and ${TN}<400,and${ChloroA}<3),"Oligotrophic"), if(${P}>15 and <=25, and${TN}>400 and <=600,and${ChloroA}>3 and <=600),"Mesotrophic"), if(${P}>25,and ${TN}>=600,and${ChloroA}>=7),"Eutrophic")

Thanks in advanced for any help!

Re: If statement calculation, Survey123

JamesTedrick — Tue, 02 Apr 2019 20:58:18 GMT

Hi Michael,

Just to check, how does the evaluation work when 2 of the variables would report one classification but one variable reports another? For example, TP = 18, TN = 380, CholoroA = 3.1(1 Oligotrophic and 2 Mesotrophic)?

For the most part, you calculation looks close to what your graph looks like; you shouldn't have commas in the evaluator section (for example, the first if should be ${P}<15 and ${TN}<400 and${ChloroA}<3 and I think your right-side parenthesis aren't lined up correctly - there should be 3 of them, one to close off each if() statement.

Re: If statement calculation, Survey123

MichaelFazio2 — Wed, 03 Apr 2019 13:45:01 GMT

Thank you, James. To be honest, I hadn't considered the values being in two different categories at once. I'll have to ask the user. As far as the statement, I'm trying a nested if statement now, but just having trouble with my brackets and/or parenthesis

Re: If statement calculation, Survey123

GrzegorzIgnatowicz — Tue, 09 Jul 2019 14:54:21 GMT

Hey folks!

According to this topic I have a problem with setting condition to auto-fill next question:

In select-one question named 'Assignee' I have few choices like 'James', 'Jessica', 'Adam'... and I want to set condition for next question named 'Assignee_Mail' to show me i.e. if 'Assignee' is James, 'Assignee_Mail' should be filled as 'james.smith@mail.com. This is very important for me because I want to use the question 'Assignee_Mail' field to set in Integromat as a dynamic value for e-mail recipient.

I tried few options for example...
if(selected(${Assignee}, 'James') or selected(${Assignee}, 'Jessica') or selected(${Assignee}, 'Adam'), ''jim@mail.com', ''jess@mail.com','adm@mail.com'))) but it doesn't work.

Could you help me please ?
Thank you in advance

Re: If statement calculation, Survey123

Anonymous User — Thu, 11 Jul 2019 00:14:27 GMT

Hi Grzegorz,

Yes it is possible to do what you want, but you need to use nested if statements, not one if statement with or expressions. It should look something like this:

if(selected(${Assignee}, 'James'), 'jim@mail.com', if(selected(${Assignee}, 'Jessica'), 'jess@mail.com', if(selected(${Assignee}, 'Adam'), 'adm@mail.com', '')))

If that doesn't work, can you send a copy of your xslx file, and I can take a closer look and let you know the best way to do it.

Phil.

Re: If statement calculation, Survey123

GrzegorzIgnatowicz — Thu, 11 Jul 2019 09:11:20 GMT

Philip Wilson‌ I can't find words to thank you! I've been struggling with this query for few days. It works now!

Re: If statement calculation, Survey123

Anonymous User — Mon, 23 Mar 2020 18:08:52 GMT

I have found this thread useful so far but there is a hang-up somewhere (calculation, type etc) that is not allowing my calculation to go through...

Context: I'd like to collect water temperature data in both Fahrenheit or Celsius but I would like the form to convert any Fahrenheit calculations to Celsius so I can have one column (hidden on the survey) on my output .csv spreadsheet. Currently, I have a decimal 'temp' variable, a select_one 'unit' variable with 'fahrenheit' and 'celsius' and now im hoping for a hidden integer field to calculate celsius based on the select_one 'unit' and decimal 'temp' fields.

decimal	temp	Water Temperature
select_one unit	unit	Temperature Unit
decimal	temp_c	Celsius

My current calculation "works"t and updates with my survey123 connect preview, however I do not get the Celsius field to populate on my preview form (currently leaving the field visible to test systems but eventually want it hidden).

if(selected(${unit},'fahrenheit'),int((${temp}-32)*0.55555),if(selected(${unit},'celsius'),int(${temp}*1),'NA'))

if unit is Fahrenheit

then int(${temp}-32*0.55555

else if unit is Celsius

then int(${temp}*1

else NA

Does my current calculation reflect that?

If I want a decimal output in my hidden calculation what relevant columns should I be utilizing? bind: type? bind:esriFieldType?

Re: If statement calculation, Survey123

JamesTedrick — Tue, 24 Mar 2020 21:01:34 GMT

Hi Clay,

Is there a third option, as you have nested the if statement to provide a value of 'NA' if neither Fahrenheit or Celsius is selected? It does reflect what you describe, but doesn't make sense with the rest of your description. If you want decimal output, 'NA' will not be a valid value. You should set bind:Esri:fieldType to a floating point (Single/Double) field field type for decimal storage.

Re: If statement calculation, Survey123

JessicaJThompson — Fri, 16 Sep 2022 14:55:39 GMT

Hello! (Surveyt123 Connect | Version 3.14.274)

Thank you in advance for your assistance!!

I have an if/and calculation that creates a default value if 6 questions all have the same answer. However, one of the questions is relevant based on a previous response so it is is hidden on occasion, so it cannot be answered. This makes the if/and calculation void, even if all of the visible questions are have the same answer.

Is it possible to solve this with the calculation? Or do I have to rethink the workflow?

Thank you!

Jessica

Re: If statement calculation, Survey123

ArchitSrivastava — Sun, 27 Aug 2023 08:00:35 GMT

Hello All,

I am stuck with kind of a similar problem.

We have an external CSV from where want to verify the entered code. If the entered code is correct then show the rest of the questions and if the value entered in code is correct we want to provide suggestion saying that entered code is incorrect but the survey doesn't seem to try and meet the condition. We have the following if statement

We pull the code value from CSV in a field name (code) as hidden and use the following calculation

if(selected('${code}'='${enter_security_code}','${code_check}') and selected(${code}!='${enter_security_code}'),'${check_the_code}','${code_check}')

But this seems to error out a below:

It would be great if I can get any suggestions as to why this is not working. Any help would be highly appreciated.

-Archit