topic Re: Automatically update a field in an edit session in Geodatabase Questions

Automatically update a field in an edit session

JonathanBailey — Tue, 24 Feb 2015 15:02:23 GMT

Hi,

I'm looking for approaches to automatically update the value in a field using values from other fields within an edit session.

In one table, for example, I have three fields: [AD_HP], [TXT_DESIG], and [RWY_ID]. When a row in this table is edited, RWY_ID should have the value [AD_HP] & ":" & [TXT_DESIG].

Using the Field Calculator is my fallback, as I'd prefer this to happen automatically and not have to rely on the user to remember to do this.

I've also looked at using database triggers, but this doesn't work well in a versioned geodatabase scenario.

I don't see anything in Production Mapping that might help with this.

Does anyone have other suggestions that might help?

Thanks,

Jon.

Re: Automatically update a field in an edit session

JakeSkinner — Tue, 24 Feb 2015 15:30:11 GMT

Hi Jonathan,

You can do this using the Attribute Assistant that is included with the Water Utility Network Editing template:

Water Utility Network Editing | ArcGIS for Local Government

Here is the associated help:

ArcGIS for Local Government 10.2

You essentially install the add-in, add the DynamicValue table to ArcMap, add a row in this table that defines your expression, and begin your edit session. Below is example of an expression in the DynamicValue table.

Anytime a feature is created or the geometry modified, it executes the expression and updates the 'Acreage' field in the 'Parcels' layer within the map.

Re: Automatically update a field in an edit session

JonathanBailey — Thu, 26 Feb 2015 21:17:52 GMT

Thanks, Jake. That looks like what I need. Any information on when the 10.3 release of Attribute Assistant will be available?

Thanks,

Jon.

Re: Automatically update a field in an edit session

AsrujitSengupta — Thu, 26 Feb 2015 21:21:50 GMT

Its already available and supported with 10.3:

Water Utility Network Editing | ArcGIS for Local Government