topic Re: Field value not preserved when Attribute Insert Rule active in ArcGIS Pro Questions

Field value not preserved when Attribute Insert Rule active

CuyahogaGIS — Mon, 01 Jun 2020 20:25:14 GMT

I have an Attribute Rule set to trigger on Insert (using ArcGIS Pro 2.5.1). It takes the value of a field in a source layer and then adds it to the field in a target layer. It works so far that the target table gets updated. However, after insert the source field resets back to it's default of 0 (it's a number field).

When I deactive the rule the source layer gets updated normally.

Both layers are tables in a FGDB. The target table only has one row.

var fsTargetTable = First(FeatureSetByName($datastore, "Totals", ["globalid","gloves_xs"], false));

Re: Field value not preserved when Attribute Insert Rule active

HusseinNasser2 — Sat, 11 Dec 2021 22:15:53 GMT

Hello!

Hope I can help, the reason the value is getting set to 0 is because you haven't provided a result in the return payload. thus the default will be used..

If you want to preserve the field value you input just simply return it back as follows..

var fsTargetTable = First(FeatureSetByName($datastore, "Totals", ["globalid","gloves_xs"], false));
var glovecount = $feature.gloves_xs;
var totalglovecount = fsTargetTable.gloves_xs;
totalglovecount += glovecount;
var AddList = [];
AddList[0] = {
 'globalid':fsTargetTable.globalid,
 'attributes':{
 'gloves_xs':totalglovecount
 }
 };
return {
 'result': $feature.yoursourcefieldname, 
 'edit': [{
 'className': 'Totals',
 'updates': AddList
 }]
 }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Field value not preserved when Attribute Insert Rule active

CuyahogaGIS — Mon, 22 Jun 2020 18:01:52 GMT

Thanks for the reply! This was my issue and the rule works great now.