topic Re: Survey123 Connect If statement and Pull data in ArcGIS Survey123 Questions

Survey123 Connect If statement and Pull data

MyEthiopia — Mon, 22 Jul 2024 15:43:44 GMT

Hello everyone. I am having a hard time trying to construct a statement so that the if the point drawn on the map is intersecting the feature layer to pull data from the feature layer if not to select "Not in a priority Area" from the choice field. Please help I am not knowledgeable in coding or connect

if (
within ( pulldata("@layer", "getValueAt", "attributes.Name", "https://services2.arcgis.com/sBoGufkdR7jFytOm/arcgis/rest/services/shedMap_WFL1/FeatureServer/8", ${Location_of_Project}, "")), "Not in a Priority Area"
)

Re: Survey123 Connect If statement and Pull data

DougBrowning — Mon, 22 Jul 2024 15:51:10 GMT

Pulldata does not work well inside an if. Move it out to a temp field and then check that in the if.

Re: Survey123 Connect If statement and Pull data

MyEthiopia — Mon, 22 Jul 2024 19:26:48 GMT

Thanks for reply Doug! I wish I was able to get an auto populate if a feature does not intersect with a point.

Re: Survey123 Connect If statement and Pull data

abureaux — Mon, 22 Jul 2024 20:37:58 GMT

Doug just means you need to split up the operation. You can still do what you want.

Calculate #1 is your pulldata(@layer)
E.g., pulldata("@layer", "getValueAt", "attributes.Name", "https://services2.arcgis.com/sBoGufkdR7jFytOm/arcgis/rest/services/shedMap_WFL1/FeatureServer/8", ${Location_of_Project}, "")

Calculate #2 is your IF statement.
E.g., if(${pulldata_calc}='','Not in a Priority Area',${pulldata_calc})

Not saying these calculates are correct. They are just examples. This is generally what you'd be looking to do.

Re: Survey123 Connect If statement and Pull data

TKSHEP — Tue, 23 Jul 2024 13:08:37 GMT

What if I am pulling data from a layer with polygons for a location and the point is outside the polygons boundary and in place of the polygon attribute I want to put "International" in the text field instead of the polygon attribute. I hope this makes sense. How would I do this?

Thank you!

Re: Survey123 Connect If statement and Pull data

abureaux — Tue, 23 Jul 2024 14:07:43 GMT

From your description, it sounds like when you click outside of your desired polygon area, you are clicking into "nothing", and so nothing should be returned. As has been mentioned in this thread, you should be able to set up two calculates to 1) pulldata(@layer), followed by 2) an IF() statement to test whether or not any data was returned by the pulldata(@layer)

Re: Survey123 Connect If statement and Pull data

MyEthiopia — Tue, 23 Jul 2024 14:31:30 GMT

Thank you for your help! I was able to get it to work. I used two calculation fields and it worked perfectly, but I ended up combining it.

Re: Survey123 Connect If statement and Pull data

abureaux — Tue, 23 Jul 2024 14:40:06 GMT

Glad you got it working!

Going back to what Doug already said though, sometimes pulldata doesn't like being nested within IF() statements. If it is working for you, great. But if it starts acting odd, consider breaking it out the steps into separate calculates.

Good luck.

Re: Survey123 Connect If statement and Pull data

MyEthiopia — Tue, 23 Jul 2024 21:12:39 GMT

Ended up breaking it up, and it's working both on web/desktop. I am sure you can make the code much simpler. Thanks, abureaux and Doug!!

Re: Survey123 Connect If statement and Pull data

DougBrowning — Tue, 23 Jul 2024 21:14:05 GMT

Note this may not work in a web form using that if statement if you use those.

Re: Survey123 Connect If statement and Pull data

MyEthiopia — Tue, 23 Jul 2024 21:16:24 GMT

It's working so far, hopefully it won't generate errors. Do you have any suggestions if that was the case?

Re: Survey123 Connect If statement and Pull data

DougBrowning — Tue, 23 Jul 2024 21:43:27 GMT

Sorry must not be saying it right. As posted above simply move pulldata to its own hidden field. Then the rest of your code if(${FieldWithPulldataInIt}, etc, etc) in your final field. Clear now?

Re: Survey123 Connect If statement and Pull data

MyEthiopia — Thu, 25 Jul 2024 14:51:26 GMT

Yes, thanks Doug!