Have an interesting request from a client. To keep a log of changes on information of the employer table. Obviously it will only be needed to be triggered when the update action is run.
Is there a function that could compare and check which fields changed in value? I need to then list it like this which would be the easy part:
The way I did it a fairly long time ago was to create a second identical table. I would assign an update and an insert action to the server connect. This would keep a running record of the edits. Not exactly what you are asking but it worked.
I am finding globals.json’s global action steps to be amazing for functions like this. Here’s a helpful video courtesy of Hyperbytes that shows one way to use it: https://www.youtube.com/watch?v=Mx9dcR7Hp6I
Maybe overkill since you only need it in one area, though.
