Audit Logging (i know) - Help Me Figure Out What I'm Missing

[mykrobinson]

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:

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Trouble-with-IFS-Statement-THISROWBEFORE-in-Act...

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

[Steve]

To implement an audit log, setup a bot that responds to all changes to the table. For each change, copy the columns of the new/changed row into a new row of your audit log.

[Marc_Dillon]

This might help:

https://www.googlecloudcommunity.com/gc/Tips-Tricks/THISROW-BEFORE-THISROW-AFTER-Template-Generator/...

Also, nice beard!