Recalculate a field when date field changes value

[JaronJensen7]

We use filed maps for tracking construction on features. On the features we have fields that tell us the date when a step is completed. When that date is filled in it also updates the editor of the field. Right now it changes the editor anytime there is a date, and someone makes any edit somewhere else on the feature.

I want to make it so that the editor field only changes when the tied date field is entered/ changed.

Example: 'Date Cable Approved' is entered with 'June 30th' and it calculates the 'Cable Approved Editor' as John Smith. When the fiber size field is changed from 24 to 48 fiber it will recalculated the 'Cable Approved Editor' as 'Jane Doe'. I want the 'Cable Approved Editor' field to only calculate or recalculate when the 'Date Cable Approved' field is entered/updated.

Any ideas?

[RPGIS]

Hi @JaronJensen7,

If these fields are being used as editor tracking fields then there isn't anything that you can do to change the editor field because editor tracking tracks edits on the database level and cannot be edited.

If you want to track the last editor of a feature, when certain criteria is met, then the easiest solution would be to add another field (ex: previous editor) and then set the logic to when the editor changes the fiber size and date to capture whom the editor is.