Hello fellow friends,
I’m requiring some Coda magician here. I think i saw once a post relating this matter, but I wanted to ask if you have a better way to achieve this:
Scenario:
-
You handle your projects from one, maybe bunch of docs, where you handle work in progress, consultancy results, functionalities and so. In those documents, your team update their work results, their ongoing tasks, customers information…
-
You want to share part of that work with the world. Maybe you want to create some documents explaining part of your results (such as products and functionalities), maybe you want to create separate docs with information relating to each customer.
-
Then, you are going to need a template where you prepare the format for that use (project information for customer, public page for product…). It is going to have crossdoc tables, but since when you use that template, you need to filter in origin data so no information from other (customer, product, project…) is exposed, that filter in origin is not possible at template design time
Problem:
If you create the template, and it has quite amount of tables, with its layouts, you have two options after using the template:
- Delete each table and recreate it after filtering in origin with the selected project, customer, product… so the biggest part of work at template design time (tables, layouts…) is lost and creating template is rendered almost useless effort
- Or… you have a solution I remember seen once, I think by @Paul_Danyliuk , which involved some non trivial operations so you could change that underlying cross doc connection, and you need to repeat it for each single table in doc.
One way or another, if your template involve an amount of tables it is a comparable effort to the one taken into creating such template
Is there any other way, now templates are deployed, so we have better way to change cross doc origin filters applying to that template upon its use?