topic Re: If statement in ArcGIS Survey123 Questions

If statement

GaryBowles1 — Wed, 05 Jan 2022 20:33:35 GMT

I am trying to calculate a yes or no answer for a field using the formula below.

if((string-length(${inbox_flag})=5,"yes" and string-length(${leak_tagno})>0,"yes"), 'yes', 'no')

I keep receiving invalid result and have been banging my head against the wall all afternoon. What am I doing wrong?

Thanks,

--gary

Katie_Clark — Wed, 05 Jan 2022 20:50:47 GMT

Hi Gary,

This worked for me:

if((string-length(${inbox_flag})=5 and string-length(${leak_tagno}) > 0), 'yes', 'no')

You had extra "yes" statements in there that weren't needed. Hope it makes sense!

GaryBowles1 — Wed, 05 Jan 2022 20:56:30 GMT

That worked.

Thanks!!

--gary

ChristopherMask — Fri, 20 Oct 2023 15:20:56 GMT

Good Morning Katherine,

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.

Christopher