Why is the second approach the one you prefer? In practical terms the outcome is the same, it is just many, many times easier to use the first approach.
If you do want to follow the second approach, you could implement the ForEach() formula to copy the data from the distributed to the central table.
And then you run into maintenance issues, because unlike the first approach where there is one source of truth, nie you have several, and need to keep them in sync.
Thanks for your response. I will try your suggestion
but yeah I understand it is so much easier. I am trying to create a daily report.
Basically, my use case is for the project management and my manager wants to see a daily report for all tasks from multiple projects summarised into one single table.
Therefore, the table view approach won’t meet the requirement since I don’t want to create one master task table for all projects and then create the view table with a filter in each project doc. I prefer to update tasks in each project doc and have them all combined to a single table for a management report.
If it’s complicated and require a lot of effort to set up and maintain, I will have to think of other way to do this but I was hoping that Coda may have a solution for it.
I you indeed have to have different source tables, it is still doable, as Richard pointed out. You would need to put a little bit of effort into avoiding errors of omission and commission. Also sending information back to the individual projects is possible but only with some effort.