Hello, I am trying to write a nested IF statement in Survey123 Connect, and I am having a bit of trouble with the syntax. Here is the gist of what I want to do, in Python syntax: if val1 == 'a' OR val1 == 'b' : score = 'Very Low' elif total_score 10 : score = 'Very Low' elif total_score 20 : score = 'Low' elif total_score 30 : score = 'Moderate' elif total_score 40 : score = 'High' elif total_score 45 : score = 'Very High' elif total_score > 45 : score = 'Extreme' So far, I've gotten this much to work in Survey 123: if(selected(${material}, 'a'), 'Very Low',if(selected(${material}, 'b'), 'Very Low', '0')) I seem to be able to get as far as the first IF statement and then an ELSE statement, but nesting any further is returning error messages like "cannot handle 'if' requires 3 arguments. Only 4 provided." Any help would be appreciated!! Thanks! James Tedrick

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; } } }

Nested IF statements in Survey123

Katie_Clark

Hello,

I am trying to write a nested IF statement in Survey123 Connect, and I am having a bit of trouble with the syntax. Here is the gist of what I want to do, in Python syntax:

<SPAN class="keyword token">if</SPAN> val1 <SPAN class="operator token">==</SPAN> <SPAN class="string token">'a'</SPAN> OR val1 <SPAN class="operator token">==</SPAN> <SPAN class="string token">'b'</SPAN><SPAN class="punctuation token">:</SPAN>
	score <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Very Low'</SPAN>
<SPAN class="keyword token">elif</SPAN> total_score <SPAN class="operator token"><</SPAN> <SPAN class="number token">10</SPAN><SPAN class="punctuation token">:</SPAN>
	score <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Very Low'</SPAN>
<SPAN class="keyword token">elif</SPAN> total_score <SPAN class="operator token"><</SPAN> <SPAN class="number token">20</SPAN><SPAN class="punctuation token">:</SPAN>
	score <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Low'</SPAN>
<SPAN class="keyword token">elif</SPAN> total_score <SPAN class="operator token"><</SPAN> <SPAN class="number token">30</SPAN><SPAN class="punctuation token">:</SPAN>
	score <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Moderate'</SPAN>
<SPAN class="keyword token">elif</SPAN> total_score <SPAN class="operator token"><</SPAN> <SPAN class="number token">40</SPAN><SPAN class="punctuation token">:</SPAN>
	score <SPAN class="operator token">=</SPAN> <SPAN class="string token">'High'</SPAN>
<SPAN class="keyword token">elif</SPAN> total_score <SPAN class="operator token"><</SPAN> <SPAN class="number token">45</SPAN><SPAN class="punctuation token">:</SPAN>
	score <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Very High'</SPAN>
<SPAN class="keyword token">elif</SPAN> total_score <SPAN class="operator token">></SPAN> <SPAN class="number token">45</SPAN><SPAN class="punctuation token">:</SPAN>
	score <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Extreme'</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

So far, I've gotten this much to work in Survey 123:

if(selected(${material}, 'a'), 'Very Low',if(selected(${material}, 'b'), 'Very Low', '0'))

I seem to be able to get as far as the first IF statement and then an ELSE statement, but nesting any further is returning error messages like "cannot handle 'if' requires 3 arguments. Only 4 provided."

Any help would be appreciated!! Thanks!

James Tedrick‌

Find more posts tagged with

Accepted answers

JamesTedrick

Hi Katherine,

First, it looks like you could combine your first 3 conditions (a, b, <10) into one evaluation as they provide the same result.

if(selected(${material}, 'a') or selected(${material}, 'a') or ${score}, 'Very Low', ...)

The next part is nesting, which you have done 1 level correctly for above:

if(selected(${material}, 'a') or selected(${material}, 'a') or ${score}, 'Very Low', if(${score} < 20, 'Low', ...))

Further nesting involves placing full if() statements inside the '...' area. Given the error message you are reporting, it's likely you may be closing off an if() statement early, causing it to see additional values in the next higher up if()

if(selected(${material}, 'a') or selected(${material}, 'b') or ${score}, 'Very Low', if(${score} < 20, 'Low', if(${score} < 30, 'Moderate', if(${score} < 40, 'High', if(${score} < 45, 'Very High', 'Extreme')))))

I find it easiest to do this properly by typing if() when beginning a function and then going inside the parenthesis to fill the values out - that way, you always have the parenthesis in the right place. Note that you don't need an if() for the final value - it's an else (just like you don't need an elif in the python sequence; an else would have produced identical results)

All comments

Melanie_K

Hi James, I wanted to reply and say that I just used this response to solve a nested if statement issue I was having a few minutes ago. Thanks so much for the clear explanation!!

ThomasM

So that documentation only covers the example I gave in my question: how to do an "if" for a single selected choice. I have been unable to find any documentation on having an "if" statement that has multiple possible selections be valid. I would expect something along these lines, but I haven't found a way that works yet:

${if field_name | selected:"choice1 OR choice3 OR choice5"}

Katie_Clark

Hi @ThomasM ! You might find it helpful to look at the "Conditional Report Elements" section of this documentation

The syntax is slightly different for the reports compared to within the XLS form.

If you have a more specific question after reading that, let me know and I'll do my best to assist. 🙂

ThomasM

I'm looking to do this exact "if selected OR if selected" type statement, but in a survey report. I know I can use:

${if field_name | selected:"choice1"}

to see if a single choice is selected, but how how do I make that if statement work if I want it to evaluate to "True" if choice1 or choice3 or choice5 are selected (as in a true "OR" statement - any or all of them can be selected)?

Katie_Clark

James,

Thank you SO much for your quick reply and extremely thorough answer. It was very helpful, and I have it working now!

Best,

Katherine

JamesTedrick

Hi Katherine,

First, it looks like you could combine your first 3 conditions (a, b, <10) into one evaluation as they provide the same result.

if(selected(${material}, 'a') or selected(${material}, 'a') or ${score}, 'Very Low', ...)

The next part is nesting, which you have done 1 level correctly for above:

if(selected(${material}, 'a') or selected(${material}, 'a') or ${score}, 'Very Low', if(${score} < 20, 'Low', ...))

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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