Copy value to a table in another doc

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!

1 Like

Okay, the answer is more trivial then I thought.
In fact it is possible to create “Cross-doc” column types, where I could create a “Modify row” which can actually modify values in the cross-doc table with using the rowurl reference.

So it is working with cross-doc bringing Table A to a different doc and then adding columns and values in the cross-doc and then send the new columns value back to the original Table A.

Then there is another Pack called Cross-Doc Actions via API (No Sync Tables Required!). With this I don’t even need to bring Table A with cross-doc but it can map all my docs in my account and send information there, but I didn’t find how to refer to a value with a formula, not only sending a text string…

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.