topic Re: Correct syntax for evaluating integers in If statements in ArcGIS Survey123 Questions

Correct syntax for evaluating integers in If statements

bobwright — Thu, 12 Sep 2019 19:04:48 GMT

Greetings,

I am trying calculating a field based on an If statement: if(selected(${section},'>=1'),${town},${permit_area}). However, this does not appear to be working because it always produces the false response (${permit_area}). If I do this: if(selected(${section},'1'),${town},${permit_area}) and set ${section} to 1, it produces the true response (${town}. I'm assuming it's a syntax error in the former and I've tried everything I can think of. I do not get error messages with either of these approaches. The evaluation attribute (${section}) is integer. I have tried it with the field I am trying to calculate defined as string and with no definition. Any help would be greatly appreciated.

Bob

Re: Correct syntax for evaluating integers in If statements

DougBrowning — Thu, 12 Sep 2019 20:00:32 GMT

If I follow I think your issue is that drop down lists are always strings. So using a >=1 makes no sense.

The way it is written you are asking if the string '>=1' has been selected.

Re: Correct syntax for evaluating integers in If statements

bobwright — Thu, 12 Sep 2019 20:55:13 GMT

Hi Doug,

Thanks for the response. It is straight data entry, or a feed from Explorer for ArcGIS. See below. If the user enters a value for Section, then I want to calculate the field of interest (hidden) with Township ($). If Section is missing, I want to populate the field of interest with DPA. All are of type Integer. Does that help any?

Bob

Re: Correct syntax for evaluating integers in If statements

DougBrowning — Thu, 12 Sep 2019 21:13:25 GMT

The selected command is for drop downs not data entry. And I think all drops downs are string. So you are kinda losing me.

Re: Correct syntax for evaluating integers in If statements

bobwright — Thu, 12 Sep 2019 21:28:50 GMT

Sounds like the Select option is the wrong approach, but if so, I’m not sure why a specific value works. (I did try it Section as a string format.) Here is what I am trying to do: “If there is a legitimate value for Section, then the location resolution ($) is “TRS”; otherwise it is “DPA”.

Re: Correct syntax for evaluating integers in If statements

DougBrowning — Thu, 12 Sep 2019 22:20:17 GMT

If you mean just check if it is blank then

if(${section}="",${town},${permit_area})

If section is a number I think you have to do this if I remember right. Yea I know string length on a number but until it is filled in it is blank.

if(string-length(${section})=0,${town},${permit_area})

Re: Correct syntax for evaluating integers in If statements

LanceCole — Thu, 12 Sep 2019 23:51:57 GMT

bob wright‌

Two suggestions:

"section" is a reserved word in XMLForms. If that is the name of your selection type or text box you may want to use something different such as "section_num"
try using the following assuming you are checking against a select_one field or text box:

if(${section_num} >= 1, ${town}, ${permit_area})

This will return {town} for any value grater than 1 if it is selected/input in {section_num} and {permit_area} if zero or less. I am not quite sure if you are using a dropdown or text field.

Re: Correct syntax for evaluating integers in If statements

bobwright — Fri, 13 Sep 2019 17:37:30 GMT

Lance Cole I did try the code you suggested with ${section}, but was still getting error messages. I did not know section was reserved, hence the unexplained squirreliness. Your suggestion to use something else worked. Thanks!

Re: Correct syntax for evaluating integers in If statements

DougBrowning — Mon, 16 Sep 2019 19:30:55 GMT

Opps missed the Reserved Word. Note that in Excel on the Types tap it lists all the reserved words for you.