topic Re: Conditional (if / then / else) logic in Survey123 using numeric answers in ArcGIS Survey123 Questions

Conditional (if / then / else) logic in Survey123 using numeric answers

SilverwoodConsulting — Fri, 19 Mar 2021 19:40:23 GMT

Hi there,

I'm trying to use conditional if / then / else logic in Survey123 to take a range of numeric values calculated in (question_one) and assign it a value accordingly.

I've tried modifying this script (from: https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION2_BED1A394912441F3833B6D15DE3D6FB5😞

if(condition, a, b)

If the condition evaluates to true, returns a; otherwise, returns b.

if(selected(${question_one}, 'yes') and selected(${question_two}, 'yes'), 'yes', 'no')

The conditional logic would be something like:

if(${question_one} > 1.0 and < 1.9) then assigned_value = '500mm'

if(${question_one} > 2.0 and < 2.9) then assigned_value = '600mm'

else(${question_one} > 2.0 and < 2.9) then assigned_value = '700mm'

I've tried this format (and similar variations):

if(${Q100} > 0.5), '500'

Note: question_one is a numeric field (decimal) that calculates a total based on other fields in the form (i.e. an average). The assigned_value field would then use that auto-calculated numeric value field and categorize the numeric values based on ranges (i.e. 1.0 to 2.9 or >= 1 and <= 2.9).

Is this possible within Survey123. Does anyone have experience using a similar loop conditional statement?

Thanks in advance for your help!

Re: Conditional (if / then / else) logic in Survey123 using numeric answers

DougBrowning — Fri, 19 Mar 2021 21:10:40 GMT

You are just having some syntax issues.

First you always need to build both sides of an And or Or.

if(${question_one} > 1.0 and ${question_one} < 1.9, '500mm', 'no')

123 does not have esleif so it does get harder to chain them together. But it goes like this

if(${question_one} > 1.0 and ${question_one} < 1.9, '500mm', if(${question_one} > 2.0 and ${question_one} < 2.9, '600mm', if(${question_one} > 2.0 and ${question_one} < 2.9, '700mm', 'none of the above')))

So same logic, it just needs to be written on all one line. if(condition, true, false) Hope that helps.

Re: Conditional (if / then / else) logic in Survey123 using numeric answers

SilverwoodConsulting — Tue, 23 Mar 2021 21:30:17 GMT

Thank you! This worked out perfect! 🙂

Re: Conditional (if / then / else) logic in Survey123 using numeric answers

EduMoldovaAdmin — Wed, 06 Sep 2023 09:15:21 GMT

Dear colleagues,

I am struggling with very simple question. Please help to sort i out. I have a string quesion {crop} with dropdown and one choice should be selected. Have another string quesion {alt_crop} to polulate based one choice from {crop}.

Struggling with syntaxis here (not working):

if(selected(${crop},'Corn'), 'Winter wheat', if(selected(${crop},'Winter wheat'), 'Sunflower', 'na'))

Survey is done based on existing layer ({crop} haas domains

what is wrong here?

Re: Conditional (if / then / else) logic in Survey123 using numeric answers

RobertAnderson3 — Wed, 06 Sep 2023 15:22:06 GMT

What is happening when you try to save/run the calculation? The first thing that comes to mind is use the domain values, not the display names as I was encountering this earlier with a colleague.

Re: Conditional (if / then / else) logic in Survey123 using numeric answers

ChristopherMask — Wed, 18 Oct 2023 18:31:45 GMT

Hello Doug,

I wanted to see if you could help on this?

if((${ResourceType}="Personnel", ${HourlyCost}, " "), if(${ResourceType}="Equipment", ${OthersCost}, " "))

Re: Conditional (if / then / else) logic in Survey123 using numeric answers

ChristopherMask — Wed, 18 Oct 2023 18:36:20 GMT

I used this and it worked

coalesce(${HourlyCost},${OthersCost})

Re: Conditional (if / then / else) logic in Survey123 using numeric answers

ChristopherMask — Fri, 20 Oct 2023 15:22:50 GMT

Good Morning Doug,

Wondered if you would give this a quick look.

The name columns Two09 and Two09Calc. It currently has this for the calculation:

if((${FinalFireAcreQuantity}>=300 and $NumberFatalities} >=1), 'Yes','No')

If statement is true, then Two09 = Yes, if not Two09 = No.

Re: Conditional (if / then / else) logic in Survey123 using numeric answers

DougBrowning — Fri, 20 Oct 2023 16:01:45 GMT

You are missing a { ${NumberFatalities} see in bold

if((${FinalFireAcreQuantity}>=300 and ${NumberFatalities} >=1), 'Yes','No')

Re: Conditional (if / then / else) logic in Survey123 using numeric answers

ChristopherMask — Fri, 20 Oct 2023 17:08:46 GMT

Goodness, that worked! Thanks for the response and have an excellent weekend!

Also, change to an or statement. if((${FinalFireAcreQuantity}>=300 or ${NumberFatalities} >=1), 'Yes','No')

Christopher

Re: Conditional (if / then / else) logic in Survey123 using numeric answers

AmandaBeck — Tue, 24 Oct 2023 13:51:42 GMT

I'm hoping you can help me out with this one.

I want to have a conditional statement after a geopoint question is completed.

If you select within a parcel, then you are within the boundary. If you select outside of a parcel, you are outside the boundary.

Any help is appreciated. Thanks!

Re: Conditional (if / then / else) logic in Survey123 using numeric answers

BryceHancock — Mon, 15 Jul 2024 23:17:02 GMT

I am trying to evaluate 2 if statements in the calculate field of an xls form and the following works for the 1st statement but not the 2nd (the 2nd statement is in bold):

if(selected(${RMZ_CLASS}, 'CAT_1') or selected(${RMZ_CLASS}, 'CAT_2') or selected(${RMZ_CLASS}, 'CAT_3'), ('100 Feet'), '0 Feet' or if(selected(${RMZ_CLASS},'CAT_4'),('50 Feet'),'0 Feet'))

When I choose CAT_1, 2, or 3 in the list '100 Feet' is returned in the field, but if I choose CAT_4, '0 Feet' is returned, when it should return '50 Feet'.

Anyone have ideas where I am going wrong?

Re: Conditional (if / then / else) logic in Survey123 using numeric answers

DougBrowning — Mon, 22 Jul 2024 14:57:31 GMT

You have 2 else statements and too many parenes try this

if(selected(${RMZ_CLASS}, 'CAT_1') or selected(${RMZ_CLASS}, 'CAT_2') or selected(${RMZ_CLASS}, 'CAT_3'), ‘100 Feet', if(selected(${RMZ_CLASS},'CAT_4'),'50 Feet','0 Feet'))

Re: Conditional (if / then / else) logic in Survey123 using numeric answers

TKSHEP — Tue, 13 Aug 2024 16:45:08 GMT

@DougBrowning I am trying to also do something similar, however with months in a year. I am trying to use a conditional calculation to autofill the fiscal year. I have this,

format-date(${inspection_date}, '%n'), if(${inspection_date } =< 1 and ${ inspection_date } =>3, 'Q2', and if(${inspection_date}=1 or 2 or 3, 'Q2') and if(${inspection_date}=4 or 5 or 6, 'Q3', 'Q4'))

however I am getting an error and was wondering if you could help me with it.

Thank you so much for your help.

Re: Conditional (if / then / else) logic in Survey123 using numeric answers

DougBrowning — Tue, 13 Aug 2024 19:50:21 GMT

Do you have this all in one field or something? If so that is not the correct way, this statement above just has a function at the front. Also all of your syntax is incorrect.

You need to split this to 2 fields.

Field_1 is format-date(${inspection_date}, '%n') note set to integer type and appearance as hidden. Set bind::type to null if you do not want this field in the final schema.

Then Field_2 uses the value from Field_1

Easier to read this way and proper syntax

if(${Field_1} <= 3, 'Q1', if(${Field_1} >= 4 and ${Field_1} <= 6, 'Q2', if(${Field_1} >= 7 and ${Field_1} <= 9 'Q3', 'Q4')))

Would be a good idea to read up on how if statements work in general. if(condition, true, false)

Re: Conditional (if / then / else) logic in Survey123 using numeric answers

DougBrowning — Mon, 25 Nov 2024 14:02:16 GMT

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-pulldata-quot-layer/ba-p/1224415