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

[SilverwoodConsulting]

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_BED1A39...😞 

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!

SJ

[DougBrowning · Accepted solution]

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.

[SilverwoodConsulting]

Thank you! This worked out perfect! 🙂

[ChristopherMask]

Hello Doug,

I wanted to see if you could help on this?

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

[ChristopherMask]

I used this and it worked

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

[ChristopherMask]

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.

[DougBrowning]

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

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

[ChristopherMask]

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

[AmandaBeck]

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! 

[EduMoldovaAdmin]

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?