Yes, sorry about that I realized after I posted 😂. But really thank you so much for helping!

As it says in the error message, you need to activate the "Exclude from application evaluation" checkbox in the Attribute Rule creation panel.

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

Editing Atrribute Table with Arcade

klewis47

Deleted

Najděte více příspěvků označených jako

Arcade

Accepted answers

All comments

RudyProsser

Klewis47,

Which Arcade profile and ArcGIS app are you using? Since you posted under ArcGIS Online, I'm assuming you're using the Field Calculation profile. In that profile, Arcade returns either a date, a number, or text. Your code is returning a dictionary which is not available for Field Calculation.

JohannesLindner

This is a Calculation Attribute Rule.

JohannesLindner

To post code in the community (much more legible than plain text or screenshots):

The update dictionary needs to know on which row it should apply the edit. For that,. it uses the globalID or objectID key. For further reading: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/attribute-rule-dictionary-keywords.htm
You need to load the feature class you want to edit! You do that to get the ObjectIDs to which to apply the updates. You edit SFAM_RelationalTable, but you load SFAM_Table.
You're constructing your SQL query yourself, but Filter() can do that for you using the @ notation.
You're using an outdated method of appending elements to arrays. It works, but there is also Push().

Does this do what you want?

var rel_fs = FeatureSetByName($datastore, "MAPS_D.SDE.SFAM_Relational_Table", ['ObjectID', 'footprint_id '], false)
var id = $feature['footprint_id ']
var matches = Filter(rel_fs, 'footprint_id  = <a href="https://community.esri.com/t5/user/viewprofilepage/user-id/354972">@ID</a>')

var updates = []
var adds = []
for(var m in matches) {
    var update = {
        'objectID': m.OBJECTID,
        'attributes': {
            'footprint_area': $feature['shape_area']
        }
    }
    Push(updates, update)
}
if(Count(updates) == 0) {
    var add = {
        'attributes': {
            'footprint_id ': $feature['footprint_id '],
            'footprint_area': $feature['shape_area']
        }
    }
    Push(adds, add)
}

return {
    'edit': [{
        'className': 'MAPS_D.SDE.SFAM_Relational_Table',
        'adds': adds,
        'updates': updates
    }]
}

klewis47

Deleted

klewis47

Deleted

JohannesLindner

Oof. Writing this in a popup expression complicates the search for errors, because popups use a different set of functions than Attribute Rules. And you're using the Classic Viewer, which only makes it harder.

Some suggestions:

I accidentally copy-pasted a single space behind each "footprint_id". That might be it. Lines 1, 2, 3, 19
Push() is new and won't work in the Classic Viewer, you'll have to use the counter++ method for that.
The return won't work, because the popup expression expects a single value. You can just convert the dictionary to text (but remember to change it again when you implement this in Pro):

var d = {
    'edit': [{ //...
    }]
}
return Text(d)

Use Console statements to print variables to the console (Test the expression and look at the text output). Lines like these will tell you that a step executed successfully:

// After line 1
Console(Count(rel_fs))  // should print > 0

// After line 3
Console(Count(matches))  // should print >= 0


// After line 7
Console(m.OBJECTID)  // should print the OBJECTID of every processed related row

// After line 24
Console(updates)  // should print the updates dictionary
Console(adds)  // should print the adds dictionary

klewis47

Deleted

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Přihlásit se
Registrovat

Rychlé odkazy

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