topic Re: Calculated Value in ArcGIS Online Questions

Calculated Value

DonSjoboen — Fri, 31 Mar 2023 22:00:42 GMT

Hello,

I'm trying to add an attribute [FACILITYID] from another feature in my web map form.

I have added a form field for this (see above) and have created a calculated arcade expression that seems to work.

However, when I test this expression by creating a new point (hosted feature layer), the field just shows [object Object] and not the desired value from the other feature layer.

Hoping someone can help with this?

@XanderBakker

Re: Calculated Value

ClayDonaldsonSWCA — Fri, 31 Mar 2023 22:22:39 GMT

that's because you are returning an entire feature (i.e row) not a specific value in that row.

try changing:

return InspectCB to

return InspectCB['FACILITYID']

For the sake of learning - I would add: console(InspectCB) to line 4

then you can view the results in the console tab and see what it is doing

Re: Calculated Value

DonSjoboen — Fri, 31 Mar 2023 22:37:56 GMT

Thanks, but I have tried that and I get this error...

I've also used Console() and it too gave me nothing in the console menu. Just Null in the output.

I'm using a blank hosted feature layer to add new inspections on existing catch basins feature layer. I have editing disabled for that field I want to populate too. Wonder if there isn't something else going on.

I'm using the first example from this blog as a starting point...
https://www.esri.com/arcgis-blog/products/field-maps/field-mobility/common-calculated-expressions-for-arcgis-field-maps/

Re: Calculated Value

ChristopherCounsell — Mon, 03 Apr 2023 07:31:35 GMT

From the example you have provided you are missing an ! in the if statement.

This means that it will equate to 'if empty is true, return the empty value'.

By adding the '!' it equated to if this is NOT empty, return true (and then the value)

if (!IsEmpty(region)) {
    return region['name']
} else {
    return null
}

Re: Calculated Value

DonSjoboen — Mon, 03 Apr 2023 14:08:38 GMT

When I add the !, I don't get [object Object], but I do get an error stating the calculation failed.

So, there is something else going on that is causing this to fail.

Re: Calculated Value

DonSjoboen — Mon, 03 Apr 2023 19:00:45 GMT

Using the updated line of code (below)... I get the following error message;

var OtherCB = FeatureSetByName($map, "Other Govt and City Owned Catch Basins", ['FACILITYID'], true)

var CBinspected = Intersects($feature, OtherCB)

Console(CBinspected)

if (!IsEmpty(CBinspected)) {

return CBinspected['FACILITYID']

} else {

return null

}

The idea is to write the facility id of an existing catch basin to the new inspection on that catch basin (i.e., hosted feature layer) using a calculated expr in a form in the web map. I'm wondering if I need to (somehow) add the GlobalID of the hosted feature layer in my expression? Or if there's something else at play here?

Hoping someone has experience with adding an attribute value from one feature to another when adding a new point in a web map/app.

Re: Calculated Value

DonSjoboen — Mon, 03 Apr 2023 19:16:25 GMT

I ended up solving the issue I was having. When creating the AGO hosted feature layer, I ended up setting the Facility ID field to be not editable. Even though I could control the editing permissions of the form itself, because I still had the field in the table set to not edit, that prevented the form calculation from happening.