topic Re: Calculated fields in ArcGIS Pro in ArcGIS Pro Questions

Calculated fields in ArcGIS Pro

AleemMohammed — Fri, 27 Oct 2023 15:43:20 GMT

Hi Everyone,

I am new to using ArcGIS Pro and Arcade, I wanted to have a few calculated fields in my table, not sure what's going wrong. I wanted the user to choose a value for the CommonName field and the app would fill out the ScientificName field. So I tried using the Arcade syntax, this was what I came up with:

I know the script is reading the correct value for the CommonName because if I set the scientifiName to CommonName the value is filled in the field. However, my script is returning "What", do you know where I might have gone wrong with this?

Regards,

Aleem

Re: Calculated fields in ArcGIS Pro

CarlMorrison — Fri, 27 Oct 2023 16:12:13 GMT

You might find setting up domains helpful. https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/create-modify-and-delete-domains.htm

Re: Calculated fields in ArcGIS Pro

KenBuja — Fri, 27 Oct 2023 16:17:08 GMT

Is it possible there's an extra space in the Common Name field ("Yellow Floating Heart ")? Is there any change if you modify the first line?

var commonName = Trim($feature.CommonName);

You could also use the When function to simplify your code (also using an Implicit return)

var commonName = Trim($feature.CommonName); When (commonName == "Yellow Floating Heart", "Nymphoides peltate", commonName == "Japanese Knotweed", "Reynoutria japonica", commonName == "Invasive Phragmites", "Phragmites australis", commonName == "Himalayan knotweed", "Koenigia polystachya", commonName == "Giant knotweed", "Reynoutria sachalinensis", commonName == "Fanwort", "Cabomba caroliniana", commonName == "European frogbit", "Hydrocharis morsus-ranae", commonName == "Dog-Strangling Vine", "Vincetoxicum rossicum", commonName == "Bohemian knotweed", "Reynoutria ×bohemica", commonName == "Black dog-strangling vine", "Vincetoxicum nigrum", "What")

Re: Calculated fields in ArcGIS Pro

AleemMohammed — Sat, 28 Oct 2023 14:11:00 GMT

Hi Carl,

I did set up a domain for the CommonName field and that's what I'm using.

Re: Calculated fields in ArcGIS Pro

AleemMohammed — Sat, 28 Oct 2023 14:13:54 GMT

I don't believe so, I'm using a domain for the data entry on CommonName and I copied and pasted the names from the domain table to the code.

Re: Calculated fields in ArcGIS Pro

AleemMohammed — Sun, 29 Oct 2023 16:39:46 GMT

Thanks all for helping with this, I took another look at it and figured this code was way too simple to be giving this much trouble and I made a guess that the only other complication to this was that I was using a Domain. I was using the description of the code in the domain and that was the issue 😩. Once I switched "Yellow_Floating_Heart" for "Yellow Floating Heart" in the script:

if (commonName == "Yellow_Floating_Heart") { scientificName = "Nymphoides peltate";

it worked as expected. I slipped up on that. Thanks everyone for helping with this.

Re: Calculated fields in ArcGIS Pro

KenBuja — Mon, 30 Oct 2023 14:29:53 GMT

What you also could have done is used the DomainName function to get the descriptive name.

var commonName = DomainName($feature, "CommonName"); When (commonName == "Yellow Floating Heart", "Nymphoides peltate", commonName == "Japanese Knotweed", "Reynoutria japonica", commonName == "Invasive Phragmites", "Phragmites australis", commonName == "Himalayan knotweed", "Koenigia polystachya", commonName == "Giant knotweed", "Reynoutria sachalinensis", commonName == "Fanwort", "Cabomba caroliniana", commonName == "European frogbit", "Hydrocharis morsus-ranae", commonName == "Dog-Strangling Vine", "Vincetoxicum rossicum", commonName == "Bohemian knotweed", "Reynoutria ×bohemica", commonName == "Black dog-strangling vine", "Vincetoxicum nigrum", "What")