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.
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.
Here are some links for your reference:
Attribute operations - Attribute Assistant | ArcGIS Solutions (Field trigger)
This should give you an idea of some possible options available to you.
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.
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.