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?
1 Like
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).
1 Like