I would like to copy values from a table to another one in a different doc. The use case is the following:
We are receiving applications which has different stages during the evaluation process. We have 2 departments and I would like to handle their applications in two separate docs but I want to have another table where I can see all the applications in one table with the updated statuses. The two departments handles the different statuses of each applications in their own respective doc, but I would like to see the statuses on the summary table too. I don’t want to give any access to the summary table to the departments, so cross-doc two-way syncing will not work.
So that is why I would like to copy the status back to the summary table from the two different docs. I believe this could be a button or automation.
Did anyone do something similar? Can anyone point to the direction where can I find a solution to this?
Thanks!