While developing Packs & creating template docs there are many times when we will update and change our tables due to improvements, bug fixes, renaming, feedback and the likes. One problem we face is that when a RAW table is deleted all corresponding views and dependant tables and formulas are also deleted or broken. This can be extremely annoying especially if we have build complicated dependant tables with multiple formulas.
The solution.
Although a bit more work in the short term, and probably not needed for most simple docs, we create an intermediate table called a “Buffer” table and a simple “Re-sync” solution.
These tables need not ever be deleted. And syncs directly with our Pack tables. Should we ever accidentally delete, or have to due to major updates, our Synced tables. We can simply “Re-sync” our buffer tables to match our new updated tables.
Imagine all our “Managers” tables referenced the “Original” synced table when we deleted it. We would have to re-connect a huge amount of formulas. Now to re-sync we simply push the below buttons.
Try it by deleting one of our sync tables. You will notice the connection between the button is broken. However all other tables in the doc still work. Now when you add the table back. The button will reconnect and you can re-sync again.