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 Calculation Rule Increment Attribute Value

Luca_Schikowski

Hey guys,

I am working on an attribute rule for the devices in my utility network.

I have 2 different assetgroups: Adresses and distribution boxes. One distribution box is able to supply 96 units. So whenever a new adress is added, the user has to fill an attribute "Number" which contains the amount of units at this adress. This works fine so far.

The Distribution Box also has an Attribute called "Number_Apartments" which surprisingly contains the amount of units at this box. Here is where the fun begins. When an adress with for example 5 units is added (Attribute "Number" is 5), I want to increment the "Number_Apartments"-value automatically by 5. Sadly i can't get this done.

Do you have any idea how to solve this?

Thanks in advance!

Luca

Find more posts tagged with

Accepted answers

JimClarke

Hi Luca - it might be worth including a small diagram of how your addresses connect up to your distribution boxes. E.g. if they have junction-junction association then you may be able to use the Arcade functions specific to Utility Network like FeatureSetByAssociation

All comments

JohannesLindner

Hmm... That seems like a very rare error. Either you used some wrong inputs or there's something funky with your data.

This is not the place to get into this, though. If you want to create relationship classes (they can be useful but are rarely (never?) really neccessary), I suggest asking for help in the Data Management - Esri Community

You can also just use the filter you already have in place, I updated the code in my other anser.

Luca_Schikowski

So i tried using a relationship class but it failed with error code 160263:

https://pro.arcgis.com/en/pro-app/2.9/tool-reference/tool-errors-and-warnings/160001-170000/tool-errors-and-warnings-160251-160275-160263.htm

I understand the usage of relationship classes but it seems that its not the way how I can solve this.

JimClarke

Luca_Schikowski

Hi, my Adresses got an attribute called "box" which contains the name of the distribution box. My boxes got an attribute "name" which contains the exact same values as "box". I am using a Filter which returns all boxes with the adresses box-name:

var box_filtered = Filter(box_featuredataset, "name = @box")

Actually i never heard of Relationship Classes before. I will take a look at it. Your code is understandable and seems to do excactly what I want. I just need some time to get into relationships and will reply here if I have any more questions.

Thank you very much for your quick reply!
Have a nice day
Luca

JohannesLindner

// Calculation Attribute Rule on Addresses
// field: empty
// triggers: Insert, Update, Delete
// Exclude from application Evaluation

// if we're updating the address, but not changing the Number field, abort
if($editcontext.editType == "UPDATE" && $feature.Number == $originalfeature.Number) { return }

// get the related distribution box
var box_name = $feature.box
var box_featuredataset = FeatureSetByName(...)
var box = First(Filter(box_featuredataset, "name = @box_name"))
if(box == null) { return } // no related  box found, abort

// get the current Apartment count and calculate the new one, according to our edit mode:
// Insert: add
// Delete: subtract
// Update: subtract old, add new
var apartments = box.Number_Apartments
var change = When(
    $editcontext.editType == "INSERT", $feature.Number,
    $editcontext.editType == "DELETE", -$feature.Number,
    $editcontext.editType == "UPDATE", -$originalfeature.Number + $feature.Number,
    0 // default value
)

// instead of returning a value, we return a dictionary that follows certain rules, see
// https://pro.arcgis.com/en/pro-app/2.9/help/data/geodatabases/overview/attribute-rule-dictionary-keywords.htm
return {
    "edit": [{
        "className": "Addresses",
        "updates": [{
            "globalID": box.GlobalID,//or "objectID": box.OBJECTID
            "attributes": {"Number_Apartments": apartments + change}
        }]
    }]
}

JohannesLindner

That is absolutely possible. Question: How do you get the distribution box that belongs to an address? Do you have a foreign key field? Have you built a relationship class? Do you use spatial relationship?

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.