I have a table A of 100’s lines with the name of different projects and their status. I am updating it on a daily basis, sometimes several times a day.
I would like to create a table B which summarize the changes that happened in the table A during the past week.
I did succeed to create a table B which create a line with the project name and its new status every time the status changes in the table A. However since I may change the status several times a day, I would like to create an automation which edit the previous line if the project name already exist in the table B.
The goal is to avoid having 10’s entries and line for the same project.