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 No NA 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.

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

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Ed_

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.

Find more posts tagged with

Accepted answers

All comments

RPGIS

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

HollyTorpey_LSA

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

Ed_

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

HollyTorpey_LSA

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 }

Ed_

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?

Ed_

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.

// 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;
}

HollyTorpey_LSA

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.

kenbuja

Change line 12 to this

return `Value ${yesCount + 1}`

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.