CALCULATION RULE FOR MULTIPLE FIELDS

Question

Hi Everyone! I'm new coding and interacting with arcade, during the last weeks I've tried to implement attibute rules in order to make easier the completion of feature attributes guaranteeing data integrity.

However, once I get into this coding environment and from my poor knowledge about it, I've been trying to improve my code to make it more efficient.

Now, I've discovered that I can use just one script to calculate multiple fields, avoiding creating a single calculation rule for each field (I watched this video https://www.youtube.com/watch?v=WsO3v5kDLxg). So with that goal I started to build the code to achieve that multiple calculation in my project, but I failed misserably 🤣🤣🤣.

Not only I barely understand the sample code, I also created my own FrankenCode and even though it didn't throw any error, it doesn't work properly either.

This is the code I made:

var len = $feature.length
var wid = $feature.width
var rad = $feature.radius

if (len != 'nilReason' || wid != 'nilReason' || rad != 'nilReason') {
    var len_nr = null
    var wid_nr = null
    var rad_nr = null
    return {
        //result is a dictionary or a scalar value
        "result" : {
              "attributes" : {
                       "$feature.length_nr" : len_nr, //update field1 in the $feature 
                       "$feature.width_nr" : wid_nr,  //update field2 in the $feature 
                       "$feature.width_nr" : rad_nr
               }
        }
    }
}

Basically I have 3 main fields (length, width and radius) and 3 secondary fields (length_nr, width_nr and radius_nr), what I want to do is when any of the 3 main fieds is different from 'nilReason', all secondary fields must be calculated as null.

I hope you can help me again...

Thanks a lot.

Eduardo.

Jake_S · Accepted Answer

@EDUARDOARDILARINCON

Welcome to the amazing world of Arcade and Attribute Rules.

Your code looks good except for two small changes. Remove '$feature.' from your return. The return is looking specifficly for that field name so you returning "$feature.length_nr" is looking for a field called $feature.length_nr not length_nr. Also your return has a duplicate field. Code should look like this...

var len = $feature.length
var wid = $feature.width
var rad = $feature.radius

if (len != 'nilReason' || wid != 'nilReason' || rad != 'nilReason') {
    var len_nr = null
    var wid_nr = null
    var rad_nr = null
    return {
        //result is a dictionary or a scalar value
        "result" : {
              "attributes" : {
                       "length_nr" : len_nr, //update field1 in the $feature 
                       "width_nr" : wid_nr,  //update field2 in the $feature 
                       "radius_nr" : rad_nr
               }
        }
    }
}

There is some other cleanup you can do but its good from there.

TedHoward2 · Accepted Answer

There are some good examples with explanations in the doc here:

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/attribute-rule-dictionary-keywords.htm#ESRI_SECTION1_7FAB1948CDF14FBF9129F8E81463D71E

To answer you question, $feature should not be in your attributes dictionary.

"result" : {
    "attributes" : {
        "length_nr" : len_nr, //update field1 in the $feature 
        "width_nr" : wid_nr,  //update field2 in the $feature 
        "radius_nr" : rad_nr
    }
}

TedHoward2 · Accepted Answer

I think I understand what you're trying to do, but you can only call return once.

var cond = [[$feature.length, "length_nr"], [$feature.width, "width_nr"], [$feature.radius, "radius_nr"]]

attributes = {}
for (var i in cond) {
    if (cond[i][0] != 'nilReason') {
        attributes[cond[i][1]] = null
    }
}
return {'result' : {'attributes' : attributes}}