topic Re: Conditional (if) Statement Documentation in ArcGIS Survey123 Questions

Conditional (if) Statement Documentation

BrentKinal1 — Thu, 11 May 2017 14:11:43 GMT

I can't seem to find any good documentation on using if() statement in Survey 123, I am fine with a creating a simple conditional statement but I'm having troubles with more complex conditional statements. If anyone has a link to some good documentation on using conditional statements in S123 please share.

I am trying to get at something like this:

if(selected${listA}), ''}) or if(selected${listA}), 'notlisted'}),'None', ${listA})

Basically I want to display this contents from "listA" in a note unless it's blank or the option "notlisted" was selected, otherwise I want the note to read "None"

Also wondering if there is a way to have a "not equal to" in an if() statement?

Re: Conditional (if) Statement Documentation

JamesTedrick — Thu, 11 May 2017 15:46:39 GMT

Hi Brent,

The if statement works in the same manner as in Excel - to create complex statements, they need to be nested. Based on what you're trying to accomplish, this should be the function:

if(count-selected(${listA}) = 0, 'None', if(selected(${listA}, 'notlisted'), 'None', ${listA}))

count-selected gives us the 'unselected' case (0 choices selected). Note the paranthesis for selected- it's a function and needs to specify it's parameters. This also assumes your question is called listA

Re: Conditional (if) Statement Documentation

AndrewHargreaves2 — Wed, 21 Mar 2018 21:42:27 GMT

James Tedrick‌

I too am struggling with "if" statements. Here's my use case:

Select_one {Asset} (this has choices of 'Residential Meter', 'Backflow Preventer' etc)
If {Asset} is set to 'Residential Meter' I wish to populate a second select_one question named {Enclosure} with the answer 'meter box'
Furthermore, if {Asset} is 'Backflow Preventer' I wish to set {enclosure} to 'vault'

Thanks

Re: Conditional (if) Statement Documentation

BrentKinal1 — Thu, 22 Mar 2018 13:24:51 GMT

Unfortunately I don't think you can do a calculate on a select_one question in the current version of S123, I think it will be possible in the upcoming version. For future reference the statement would look something like this:

if(selected(${Asset}. 'Residential Meter'), 'meter box', if(selected(${Asset}, 'Backflow Preventer'), 'vault', ''))

Another option here would be to use a cascading select, this won't select the option base on the previous question, but will allow you to limit the choice for the enclosure filed based on the asset field response.

Re: Conditional (if) Statement Documentation

JamesTedrick — Thu, 22 Mar 2018 13:48:46 GMT

Hi Andrew,

btkinal_SyrUniv‌ is correct- select_one questions will be calculable in 2.7.

Re: Conditional (if) Statement Documentation

AndrewHargreaves2 — Mon, 26 Mar 2018 21:16:27 GMT

I downloaded the 2.7 BETA as James Tedrick suggested here and am using Brent Kinal expression but getting an nothing. I've included my survey and would be grateful if someone could help me out with getting this right.

Thanks

Re: Conditional (if) Statement Documentation

SteveRichards4 — Mon, 26 Mar 2018 23:01:00 GMT

I think you have your answer but for what it's worth I had some issues trying to implement nested if statements, they worked in excel but not in the Survey.

I actually found it useful for my brain (and to get it working) to break the problem down into separate 'calculate' lines, calculate is a special field type that does not display on the form it works just like a variable and can be used in the other calculations e.g

type,name,label,calculation

1/ calculate,dia_diff,Diameter Difference,${sec_6_log_dia_meas_len}-${sec_6_log_dia_disp_len}

2/ note,sec_6_log_dia_diff,Measured Difference (mm),if(${dia_diff}<0,${dia_diff} * -1,${dia_diff})

3/ calculate,dia_diff_score_low,Diameter Score < 400,if(${sec_6_log_dia_disp_len}<400,if(${sec_6_log_dia_diff}>25,0,3),3)

4/ calculate,dia_diff_score_high,Diameter Score >= 400,if(${sec_6_log_dia_disp_len}>=400,if(${sec_6_log_dia_diff}>50,0,3),3)

5/ integer,sec_6_log_score,Log Score,min(${len_diff_score},${dia_diff_score_low},${dia_diff_score_high})

The logic is:

1/ Calculate the difference between what is measured and what the machine displays

2/ Convert the measurement to an absolute value (ABV)

3/ If the log has a diameter under 400mm and the difference in measurement is >25mm this log scores a 0

4/ If the log has a diameter over 400mm and the difference in measurement is >50mm this log scores a 0

5/ The log score is the minimum of Length Score,Small Diameter Score or Large Diameter Score

I left out the log length score calculations but they are similar to diameter

I have attached the full survey if anyone wants to take a look - I have trimmed out a lot of the lookup data.

Steve

Re: Conditional (if) Statement Documentation

JamesTedrick — Tue, 27 Mar 2018 03:48:11 GMT

Hi Andrew,

Your survey is working properly on the 2.7 version I am using - can you verify the version # you are using?

Re: Conditional (if) Statement Documentation

AndrewHargreaves2 — Tue, 27 Mar 2018 14:56:13 GMT

Hi JTedrick-esristaff‌

I'm using 2.7.13 BETA as shown below. As I understand the below calculation if {obstruction} is set to 'CANNOT LOCATE' then {surface_cover} should be calc'd to 'UNKNOWN' automatically. However, I just get nothing:

if(selected(${obstructions}, 'CANNOT_LOCATE'), 'UNKNOWN','LAWN')

Re: Conditional (if) Statement Documentation

JamesTedrick — Tue, 27 Mar 2018 15:04:23 GMT

Hi Andrew,

2.7.13 is a version to early to test this functionality. You should be able to download Survey123 Connect 2.7.68, Survey123 field app 2.7.93 from the Early Adopter Community.

Re: Conditional (if) Statement Documentation

AndrewHargreaves2 — Wed, 28 Mar 2018 12:40:17 GMT

JTedrick-esristaff‌

Survey123ConnectBETA 2.7.13 is all that is available on the Early Adopter site.

Re: Conditional (if) Statement Documentation

BrentKinal1 — Wed, 28 Mar 2018 12:59:00 GMT

Andrew, You should be able to find it here: Welcome to our Feedback Community

Re: Conditional (if) Statement Documentation

AndrewHargreaves2 — Wed, 28 Mar 2018 16:38:08 GMT

Thanks JTedrick-esristaff‌ and btkinal_SyrUniv‌!!

Re: Conditional (if) Statement Documentation

deleted-user-jxpbpbjlZInj — Thu, 13 Dec 2018 16:39:12 GMT

James Tedrick‌ ... can you help with an issue I'm having with conditionals? I'm trying to tell Survey123 to assign a value based on a response from a prior yes/no question. If yes, the field gets a value of 8. If no, then it needs to perform a calculation based on two other fields. I have:

if(selected(${Dead_Tree},'yes'),8, if(selected(${Dead_Tree},'no'),'(${Highest_Pot_Score})+(${Multiple_Defects_Score})'

but this isn't working. I've tried variations on this, but so far I haven't gotten it to work. Help! Please.

Re: Conditional (if) Statement Documentation

BrentKinal1 — Thu, 13 Dec 2018 19:36:41 GMT

Hi Sunny, Try this:

if(selected(${Dead_Tree},'yes'),8, number(${Highest_Pot_Score})+number(${Multiple_Defects_Score}))

Re: Conditional (if) Statement Documentation

Anonymous User — Thu, 13 Dec 2018 21:17:31 GMT

Sunny, if you download NotePad++, then it will help you with making sure the brackets line up within this type of coding. When you place your cursor by a "(" it will then in return light up the corresponding ")" to help identify if the brackets are in alignment. I'd give Brent's answer a go...

Re: Conditional (if) Statement Documentation

Carlos_AndresCamacho_Acuña — Sat, 07 Aug 2021 16:47:52 GMT

Buenas tardes,

es posible generar un tipo de condicional para que una pregunta de una encuesta desarrollada en survey Connect 123 permita diligenciar nuevamente el valor si a pesar de no cumplir con la condición el mismo dato se ingresa por segunda vez. ejemplo, un operario captura el dato de consumo promedio de agua, este valor debe validarse respecto al promedio de los últimos meses que se tiene como información base, si el valor ingresado es mayor al promedio, pida una verificación y se vuelva a diligenciar el valor, si en esta ocasión vuelve a ingresar el mismo valor, acepte el dato y llene el registro.