I am building an application to help manage a home / apartment renovation project. This application aims to get data from this renewal project and use that data to be more accurate and reliable in the next projects.
App users are allowed to add and edit data, in order to create and modify information and update the status of the project.
However I would like to keep all the data that we collect, therefore, I am looking for a solution that will make it possible to these users to update a row without replacing the old information that it contains.
I just need that this row is considerated “out of date” and that a new row “up to date” is created.
Is there and automated way of doing this?