I need to track whenever a specific field has its value changed. I have a project status field (StatusId) and want to log into another table the new value, user making the change and date/time the change occurred.
How would I go about it?
I know in many instances an Audit system can do this, but I only need this for 1 field, so an Audit system seems like overkill, but perhaps people here will advise me otherwise.
I thought about using AJAX within the webpage itself, but then you get into all sorts of potential exceptions and problems quickly arise which is why I’m thinking doing this through the controller makes the most sense, but, once again, perhaps people here will advise me otherwise.
Thank you for any and all advice!