How can I record the changes of data in a table.

[pqkythuat1]

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.

[Joseph_Seddik]

Welcome to the community!

Start here:

Actions: The Essentials - AppSheet Help
AppSheet Automation: The Essentials - AppSheet Help

[baba_sawane]

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()

[pqkythuat1]

Thank to Joseph_Seddik and GFormMLH. I will try your solution. Have a good day.