Record the addition, modification and deletion made by a user

Hello everyone,
How can I record the activities performed by a user? For example, user 1 adds a row, user 2 modifies a row, and user 3 deletes. How can I read the activity performed by the various users?
For example user1.read Operations()
Thanks a lot

Here:

See also: Monitor app activity using Audit History

Good morning @Steve ,
is there a way to read the information and insert it into a google sheets.
Let me explain, I would like to create in Google Sheets, a sort of log file. So how to read if operator 1, has added, modified or deleted?

In the meantime, thanks for the reply.
This is a useful tool that I will use
Thanks

is there a way to read the information and insert it into a google sheets.

Not easily.

I would like to create in Google Sheets, a sort of log file. So how to read if operator 1, has added, modified or deleted?

You could implement something like this using the app itself. Attach your log sheet as a table. Set up bots to write to that log table whenever changes are made to the tables you want to audit.

If I understand correctly, this question also came to my mind. I solved enough of my need. Here’s how: I connected the same application to a common database for 8 workstations and gave them 8 different names. I also pulled this name into an empty cell using CONTEXT(ā€œAppNameā€). If I were you, I would duplicate the application for each process step (since, as I understand, different users perform the steps) and pull the names into a cell.

I’ll try your solution

1 Like