topic Field Maps and Calculated Expression in field in ArcGIS Field Maps Questions

Field Maps and Calculated Expression in field

CJCowardin — Thu, 09 Jan 2025 14:47:51 GMT

I have a field called Park Name in my form and the user selects the park from a list of options.

I have another field called Parent_Asset_ID. The asset ID's have already been assigned and each park has a parent asset id. Instead of the user having to pick this, I would like the field to fill in automatically based on the park name they selected in the previous step. How can I do this? Where would I have to put the list of Parent_Asset_ID's? I did all the parks layer to my field maps and the asset id's are in there.

Re: Field Maps and Calculated Expression in field

ZachBodenner — Thu, 09 Jan 2025 15:03:37 GMT

If there's no relationship class or anything like that to rely on, you could use a Calculated Expression on the Parent_Asset_ID field. Here's an example where I would use the value from a tree species field to populate a "general tree category" field.

if($feature.species=='Bur Oak (Quercus macrocarpa)'){ return 'Oak' } else if ($feature.species=='Ginko (Ginko biloba)'){ return 'Ginko' } else if ...

Then you just match up the appropriate asset id. Possibly a bit ham-handed, but it all depends on your setup. If the user isn't creating a feature, then you can't do an intersect, and if there's no relationship class, you can't call it out that way.

Re: Field Maps and Calculated Expression in field

CJCowardin — Thu, 09 Jan 2025 15:20:58 GMT

Thank you. I appreciate the feedback. May be time consuming with 200 parks but if it's the only way.

Re: Field Maps and Calculated Expression in field

ZachBodenner — Thu, 09 Jan 2025 15:39:19 GMT

A slightly quicker option might be the Decode function in Arcade. That one works by just using matched pairs. As an example:

var p = $feature.ParkName var assetID = Decode(p,'Park Name 1','Asset ID 1','Park Name 2','Asset ID 2', etc,'Default Value')

It's a faster type anyway, does the same thing as the multiple If-else lines.

Re: Field Maps and Calculated Expression in field

DavidPike — Thu, 09 Jan 2025 15:41:19 GMT

Might be best to create a Dictionary to store the Keys and Values, then expression using if else with HasKey() or DefaultValue()

Re: Field Maps and Calculated Expression in field

DuncanHornby — Thu, 09 Jan 2025 16:20:57 GMT

Suggest you read this blog, then follow the links to examples, you put the calculate expressions into the layers form.

Re: Field Maps and Calculated Expression in field

KerriRasmussen — Thu, 09 Jan 2025 20:25:06 GMT

@CJCowardin Does the park ID need to be filled out when the data is being collected in the field? If not, you can do some post-processing on your data and add those park IDs to the data back in the office. You can either do it manually with a field calculation or set up a python script.

Re: Field Maps and Calculated Expression in field

CJCowardin — Wed, 05 Feb 2025 13:06:24 GMT

I think I can use this example in my field maps app but just need help changing the information to fit what I have. If someone could help, that would be much appreciated.

Example:

// Create a feature set using the 'Regions' layer in the map

var regions = featuresetByName($map, 'Regions', ['name'])

// Intersect the current location with the regions and

// get the first region

var region = First(Intersects($feature, regions))

// If the current location does intersect a feature,

// return the name of the region. Otherwise, return null

if (!IsEmpty(region)) {

return region['name']

} else {

return null

}

The feature class in my map where the info would come from is County_Parks

The field with the information is Asset_ID