This has been discussed several times on the forum, but either i am daft (entirely possible, mind you) or it hasn’t been discussed in enough detail to make it make sense to me.
So here’s my particular situation. I want to log things… In particular, at this time, i just want to log activity on a certain table, but what i am missing is the how part. I realize that i need to create an automation for each table to write to another table, but i feel i am attacking the problem from the wrong angle.
So, i have a certain view that looks like this: (note: this is not real patient data, its my face and a celebrity name, etc)
I wanted to craft an action that wrote to an audit log when one of the buttons is pressed, confirmed, and turned green, but ran into a problem of not being able to access [_THISROWBEFORE] and [_THISROWAFTER] in this context, as referenced here:
So, all that said, how do i log who changed what with regards to these buttons, and how do i attack logging at a more global level to document when rows are added, or when data is modified in a row?
thank you