topic Re: Arcade: Auto-populate a field based on another field's value count in ArcGIS Field Maps Questions

Arcade: Auto-populate a field based on another field's value count

Ed_ — Thu, 07 Nov 2024 17:04:07 GMT

Good morning folks, hope all is well, so i have a field say attribute1 that has "Yes", "No" and "NA" list values to choose from in the Field Maps survey.

Then i have another field say attribute2 that will be auto-populated such that whenever the user select Yes, Arcade will count it and return "Value 1" the first time. Similarly, the next time the user select "Yes", Arcade will return "Value 2" and so on kind of like a counter.

Desired output:

Attribute1 Attribute2

Yes Value 1

Yes Value 2

No <Null>

NA <Null>

Yes Value 3

Arcade expression:

// Store the layer as a variable var layer = FeatureSetByName($map, "sf") // Filter the attribute value var YesVal = Filter(layer, "attribute1" == "Yes") // Count the number of "Yes" features var YesCount = Count(YesVal) // If the current feature's attribute is "Yes", add 1 to the count if ($feature.attribute1 == "Yes") { return "Value", yesCount + 1; } else { return null; }

Error:

Test execution error: t.charAt is not a function. Verify test data.

Re: Arcade: Auto-populate a field based on another field's value count

KenBuja — Thu, 07 Nov 2024 17:11:52 GMT

Change line 12 to this

return `Value ${yesCount + 1}`

Re: Arcade: Auto-populate a field based on another field's value count

HollyTorpey_LSA — Thu, 07 Nov 2024 17:43:08 GMT

You likely already thought of this and maybe it doesn't matter for your purposes, but this method will result in Attribute2 duplicates if Field Maps users delete features other than the newest. I get around this by adding a field to store the numbers. Then a script on that number field filters for the numbers that meet my criteria, sorts them largest to smallest, and adds 1 to the first. Then the script on my version of the attribute2 field just concatenates the value and the number from the new field.

Re: Arcade: Auto-populate a field based on another field's value count

Ed_ — Thu, 07 Nov 2024 17:51:55 GMT

Hi @KenBuja thank you for the quick response 🙂 i am still getting the same error though

Test execution error: t.charAt is not a function. Verify test data.

Re: Arcade: Auto-populate a field based on another field's value count

Ed_ — Thu, 07 Nov 2024 17:55:29 GMT

Hi Holly, thank you for your quick response as well 🙂 can you explain a bit further

like how do you do this "by adding a field to store the numbers"

Also can you please share a workable code example on "Then a script on that number field filters for the numbers that meet my criteria, sorts them largest to smallest, and adds 1 to the first. Then the script on my version of the attribute2 field just concatenates the value and the number from the new field." based on the Arcade expression i have shared?

Re: Arcade: Auto-populate a field based on another field's value count

HollyTorpey_LSA — Thu, 07 Nov 2024 18:17:06 GMT

Sure. The example I'm referring to is a tree data collection template that is used for different projects all the time. We set up a new Field Maps map for each new project with a field calculation for the project number field. Trees are numbered sequentially starting at 1 for each new project, and that number is stored in the tree number field. If I just counted the trees for the project and added one, I'd end up with duplicate tree numbers if users deleted features (if they already had trees 1, 2, and 3, then deleted tree 1, then added a new tree, the new tree would be numbered tree 3 even though I already have a tree 3). So instead I record the numbers in an integer field, sort them descending, and then add 1 to the first number in the sorted set.

Here's the script that does that:

var nextTreeNumber = 1 var projectNumber = upper($feature.ProjectNum) // If this is an existing feature with a Tree Number, return that if ($editcontext.editType == 'UPDATE') { if(!IsEmpty($feature.TreeNumber)) { return $feature.TreeNumber } } // Otherwise, get tree number values for the whole Arborist Template featureset // Check that the featureset isn't empty if (!IsEmpty(first($featureset))) { // Query the featureset for trees with the same project number (even if it's null) if (isEmpty(projectNumber)) { var projectTrees = filter($featureset, "ProjectNum IS NULL") } else { var projectTrees = filter($featureset, "UPPER(ProjectNum) = @projectNumber") } if (!IsEmpty(first(projectTrees))) { var maxTreeFeature = First(OrderBy(projectTrees, "TreeNumber DESC")) // if there are no trees with the same project number, return 1 if (maxTreeFeature.TreeNumber == null) { return nextTreeNumber } // if there are trees with the same project number, add 1 to the highest one var maxTreeNumber = maxTreeFeature.TreeNumber nextTreeNumber = maxTreeNumber + 1 return nextTreeNumber } else { return nextTreeNumber } } else { return nextTreeNumber }

Re: Arcade: Auto-populate a field based on another field's value count

Ed_ — Thu, 07 Nov 2024 18:22:57 GMT

Thanks Holly that's useful but i think it'll be needed for this project but it might be useful for another project in future so thank you so much 🙂

Right now i am still trying to figure out why i am getting that error

Re: Arcade: Auto-populate a field based on another field's value count

HollyTorpey_LSA — Thu, 07 Nov 2024 18:50:25 GMT

What happens if you only use one equals sign in the query in your filter parameters? ("attribute1 = 'Yes'")

Re: Arcade: Auto-populate a field based on another field's value count

Ed_ — Thu, 07 Nov 2024 18:54:55 GMT

then it returns an error for the Filter Function Invalid variable assignment

Re: Arcade: Auto-populate a field based on another field's value count

Ed_ — Thu, 07 Nov 2024 18:58:23 GMT

This is the how Attribute1 actually looks like

and this is Attribute2

Re: Arcade: Auto-populate a field based on another field's value count

DougBrowning — Thu, 07 Nov 2024 19:04:17 GMT

You are using YesCount at the beginning but in the loop you have yesCount. That could be it.

But as posted this will all break if someone deletes a record in the middle.

Re: Arcade: Auto-populate a field based on another field's value count

KenBuja — Thu, 07 Nov 2024 19:11:13 GMT

Since that field has Domains, are you using the same value for Label and the Code?

Re: Arcade: Auto-populate a field based on another field's value count

HollyTorpey_LSA — Thu, 07 Nov 2024 21:00:49 GMT

So your line 5 now looks like this?

var YesVal = Filter(layer, "attribute1 = 'Yes'")

And as @KenBuja said, if your code and label are different, you could be getting an empty featureset from that filter. Maybe wrap that count expression with an if statement checking if your featureset is empty.

if (!isEmpty(first(YesVal))) { var YesCount = Count(YesVal) } else YesVal = 0

Re: Arcade: Auto-populate a field based on another field's value count

RPGIS — Thu, 07 Nov 2024 21:05:25 GMT

Hi @Ed_ ,

Try the solution below. My assumption is you it may be something to do with the layer name but it is hard to say what the issue is.

// Store the layer as a variable var layer = FeatureSetByName($map, "sf") // Filter the attribute value and count values var FilterField = "attribute1" var FilterValue = 'YES' var YesCount = Count( Filter( layer , FilterField + ' = @FilterValue' ) ) // If the current feature's attribute is "Yes", add 1 to the count iif ($feature.attribute1 == "Yes" , yesCount + 1 , null )

Also, is your problem similar to the one found on stack overflow. Because if it is, then that would help anyone else here point you in the right direction.

Similar sounding issue

Re: Arcade: Auto-populate a field based on another field's value count

Ed_ — Thu, 07 Nov 2024 21:27:51 GMT

Hi @KenBuja , thank you for pointing that out so yes the domain values and labels are the same as you can see below

However, as if this moment they are no Yes values in the attribute it self, right now they are all Not rated