topic Re: How to use "if" and "then" on survey 123? in ArcGIS Survey123 Questions

How to use "if" and "then" on survey 123?

Marcos_AntonioLima_Rios — Wed, 09 May 2018 12:09:59 GMT

Hi, guys. First of all sorry for my poor english.

I need to know how to use "if" and "then" to set a value.

For Exemple:

I have a fild that need to display a value to the user:

If (totalbrocasha "greater than" 3000 then coposliberar "equal" 12)

Re: How to use "if" and "then" on survey 123?

IsmaelChivite — Wed, 09 May 2018 13:45:49 GMT

The following expression will return 12 if totalbrocasha is greater than 3000 and otherwise, it will return 0.

if (${totalbrocasha}>3000,12,0)

You can use this expression in the calculation column of the coposliberar question.

The Quick reference—Survey123 for ArcGIS | ArcGIS is a great topic to learn all the things you can do with formulas in XLSForms.

Re: How to use "if" and "then" on survey 123?

Marcos_AntonioLima_Rios — Wed, 09 May 2018 14:27:40 GMT

Nice, it's works. Thank you so much.

I have one last doubt:

And if I have more arguments?

For exemple:

if totalbrocasha <= 399 then coposliberar need to be 0

if totalbrocasha >= 400 and <= 2999 then coposliberar need to be 8

if totalbrocasha >= 3000 and <= 3999 then coposliberar need to be 12

if totalbrocasha >= 4000 and <= 5999 then coposliberar need to be 18

and finally if totalbrocasha >= 6000 then coposliberar need to be 22

Re: How to use "if" and "then" on survey 123?

Marcos_AntonioLima_Rios — Wed, 09 May 2018 19:19:56 GMT

I've tried this way:

if(${totalbrocasha}>6000,22,if(${totalbrocasha}<=5999>=4000,16,if(${totalbrocasha}<=3999>=3000,12,if(${totalbrocasha}<=2999>=400,8,0))))

But the result is aways "0".

Re: How to use "if" and "then" on survey 123?

JoeBorgione — Wed, 09 May 2018 19:35:13 GMT

Nested if statements are really tough sometimes. These are a lot like what is used in attribute assistant: All methods - Attribute Assistant | ArcGIS Solutions (scroll down to additional functions). I suggest working with your statements one at a time, adding as you go. See: https://community.esri.com/thread/183208-iif-function-in-dynamic-value-table

Re: How to use "if" and "then" on survey 123?

Marcos_AntonioLima_Rios — Wed, 09 May 2018 20:27:17 GMT

Thank you for your help, Joe.

I've tried the solution that works for IIF function in Dynamic Value table (using 0, Null, <Null>, 00, "", [#] and "Nothing", like Jennifer Stone did).

But I still receiving only 22 or 0 as a final result.

Re: How to use "if" and "then" on survey 123?

JoeBorgione — Wed, 09 May 2018 21:38:50 GMT

I wish I could provide more help but I'm just not that good with xls expressions. That said, does you data coupled with your logic support any other results than 22 or 0?

Re: How to use "if" and "then" on survey 123?

JamesTedrick — Wed, 09 May 2018 21:57:21 GMT

Hi Marco,

Your evaluations for the if() functions after the first will not work - what you are trying to do would require a compound statement (i.e., ${totalbrocasha}<=5999 and ${totalbrocasha}>=4000 ). That being said, with a nested structure like this, you don't need one side of the limit - it's already taken care of by the previous statement (i.e., the <=5999 is unnecessary as you already have caught all values larger with the first evaluation >=6000 ).

Re: How to use "if" and "then" on survey 123?

Marcos_AntonioLima_Rios — Thu, 10 May 2018 12:01:59 GMT

Thank you so much. I followed your advice:

"I suggest working with your statements one at a time, adding as you go."

And it works! I appreciate your help.

Re: How to use "if" and "then" on survey 123?

Marcos_AntonioLima_Rios — Thu, 10 May 2018 12:07:12 GMT

Thank you so much.