I have a page with multiple interconnected tables. I often need to duplicate the entire page as an unlinked copy because I need to make significant changes to most of the tables. However, there are 5 tables on the page whose data should remain consistent across this duplication and other duplicates I’ll be creating in the future.
To achieve this, I need a quick way to set these 5 tables as views of their source tables, while ensuring all other tables in the duplicated page remain unlinked duplicates with their connections intact.
I was hoping for a feature like a right-click option on a table to “Convert Table to View of…” or something in the table’s Connections settings to re-sync it with the source.
Does anyone know of a workaround or have tips for managing this kind of scenario?
Ok, if anyone is having the same question, I figured out a solution - by reversing the approach.
Duplicate the page as Connected instead of duplicate, leave the 5 tables as connected, but then for the tables I want to modify without sending changes upstream, I cut the table, paste it to replace it with a duplicate.
Steps:
Duplicate the page as Connected instead of duplicate
Leave the 5 tables as connected, but then for the tables I want to modify without sending changes upstream:
Right-click the table and Copy
Then Delete the table
Then paste it back to the same spot and choose “Create duplicate”.
This way the tables that need modifying are not Views, but are editable, and their connections to the 5 tables (and each other) are restored.
Note:
For some reason cut/paste doesn’t work, pasting it just restores it as a View (connected)
The copy-delete-paste step seems to slow the doc temporarily (things like undo / redo are slow for a while).
Thanks so much for posting your solution, @Adam_Maggs ! We’ve also logged a feature request vote for you for the ability to create connected views from a duplicated table.