I'm building a basic CRM system based on channel entries and SafeCracker forms for a client extranet. The client is asking me if it's possible to view a 'system notes/audit trail' for each entry so they can keep track of who has edited a channel entry and what they edited.
I've told them we can enable channel entry versioning, but this only lets them see the date/time and author of changes at a glance, and you have to manually re-load a version and compare it to another to see what has changed.
So my question is, is there another way to show some sort of audit trail of edits made to specific fields within ExpressionEngine? If so, how?
Using the built-in versioning is my worse case scenario, but it seems limited in how you view them at a glance. A slightly better (albeit, hacky) idea is to have a custom script that would compare entry versions between two versions, in order to list out the exact changes between them, but I'm hoping that there's a better solution out there again that someone has implemented before.