Hello dear community users,
Who can clarify a doubt for me? Just to make sure I’m not going to spend hours and hours on something turning out to be obsolete… I read many topics searching for a solution, but could not find any. In case this question has been asked already: sorry!
When syncing views of tables using cross-doc from DocA into DocB (DocA containing both the ‘base’ tables and corresponding filtered views, importing only the filtered views into DocB via cross-doc in order to prevent certain elements from DocA being displayed in DocB) all connections (lookups/filters) between those tables get lost in DocB, due to Coda requiring to sync the original tables, right?
I’ve tried to manipulate the lookup formulas by changing them into filters using the views rather then the ‘main’ tables, but unfortunately Coda keeps on detecting its ‘just’ a view, referring to its corresponding ‘base’ table in the resulting rows (confirmed by expanding the row within any cell of the formula column and checking the ‘Row from’-indication on the upper left corner) hence the connection gets lost again after syncing in DocB stating ‘Table not found’…
As my goal is not having to sync ‘base’ tables with sensitive data, is it true to say I will need 3 docs at the end? DocA containing the original data, DocB with filtered data only and ‘re-establishing’ the connections between tables by means of new lookup/filter columns, and last but not least a DocC whereto the results can be synced once again, but this time with all lookups/filters working?
Edit: Just discovered this doesn’t do the trick either as DocC now states ‘Row not found’ on the columns using Lookups/Filters, despite having synced the entire tables from DocB to DocC (unlike views only in DocB synced from DocA). DocB contains the extra columns to ‘fix’ the broken connections from DocA, referring to tables from within its own doc only. What am I missing here? Or am I asking something from the cross-doc functionality it doesn’t support (yet)?
It looks like the only way to achieve this is to copy the result of the lookup/filter column using ToText into another column and use that column in the other doc to re-connect it to the corresponding values again, am I right?
Edit2: I’ve created 3 docs to demonstrate the case:
Thanks for taking time in reading this and thank you even more if you’re able to give an answer! Hopefully I expressed myself clear enough and hopefully there’s a better way of achieving this… Please take into account I’m a single person, just a Pro user, so no Team plan for me!