topic Re: Automatically calculate a field based off another field in Data Management Questions

Automatically calculate a field based off another field

ChrisCyphers — Tue, 01 Oct 2019 13:22:36 GMT

I'm trying to calculate a field based off another field each time a new feature is created or when the field being calculated from is changed. For example, I have a sewer cleaning line feature class with a "Date Cleaned" field and a "Years Since Cleaned" field. I want the "Years Since Cleaned" field to auto populate with the number of years, today's date minus "Date Cleaned" field to give me a number, or automatically change when the "Date Cleaned" field's data is modified or new data is added.

Re: Automatically calculate a field based off another field

Asrujit_SenGupta — Wed, 02 Oct 2019 09:30:33 GMT

Where is the data stored? In a File gdb, Enterprise gdb, etc?

Re: Automatically calculate a field based off another field

ChrisCyphers — Wed, 02 Oct 2019 14:04:08 GMT

Currently the data is in a file geodatabase which is zipped and uploaded to Portal for ArcGIS as a hosted feature layer. This is done to test as the project is developed. Eventually the data will be uploaded to an enterprise database and published as a service.

Re: Automatically calculate a field based off another field

Asrujit_SenGupta — Thu, 03 Oct 2019 05:11:55 GMT

Here are some links for your reference:

arcgis desktop - Automatically update field value in one column based on change to another column in same table? - Geogr…

arcgis desktop - Automatically calculate field with every new entry? - Geographic Information Systems Stack Exchange

Attribute Assistant | ArcGIS Solutions

Attribute operations - Attribute Assistant | ArcGIS Solutions (Field trigger)

This should give you an idea of some possible options available to you.

Re: Automatically calculate a field based off another field

MichaelVolz — Thu, 03 Oct 2019 14:54:41 GMT

If you do go down the Attribute Assistant (AA) route, remember that AA is tied to ArcMap that will eventually be deprecated and replaced by Pro (still many years away) and its associated Attribute Rules. If you can, I would suggest trying to get this set up in Pro so you don't have to perform this task twice.

Re: Automatically calculate a field based off another field

ChrisCyphers — Thu, 03 Oct 2019 20:05:13 GMT

Thanks, I'll take a look at these links.

Re: Automatically calculate a field based off another field

ChrisCyphers — Thu, 03 Oct 2019 20:07:16 GMT

You are correct in the fact that I should try to create this in ArcGIS Pro. However we are using ArcFM on top of ArcMap which creates extra tables in the enterprise database that are updated when editing features so Pro may not be an option for us right now.