Hi everybody,
I am making an application for 5 users, all users can change the data. In this application, how can I know what information has been changed, how can I record the changes of data in a table.
Thanks everyone.
Welcome to the community!
Start here:
Actions: The Essentials - AppSheet Help
AppSheet Automation: The Essentials - AppSheet Help
Hi @pqkythuat1 ,
You can create a new table in your database, with the same column as your original table. Also add an [ChangeID] column.
Add an automation to your original table with these conditions :
When this event occurs : [All changes]
Run this process :
[Add new rows] to [Duplicated table]
Then select every columns of your duplicate table and set the value to [_THISROW] .[Column name] (exept for ChangeID column which value will be uniqueid()
Thank to Joseph_Seddik and GFormMLH. I will try your solution. Have a good day.
User | Count |
---|---|
42 | |
29 | |
28 | |
14 | |
14 |