Hi Guys,
Wondering if this is possible.
I currently have a RAG status field within my account form which tells us if our clients are happy, sad etc. What I want to be able to do is if the field content changes from Green to Red I want to be able to report that it changed from Green to Red.
I know i can look at the audit trail to see the change, however, im looking for another way to get this done as I know audit trails cant be recorded or reports etc in the system.
Has something like this been built out before.