Sync Vs Relationships
There is a great blog here about the pros and cons of Cross App relationships, vs sync, vs table imports. Sharing Data Across Quick Base Apps: Part 1 Cross App Relationships, Table to Table Imports...
Forum Discussion
Hi Michael,
That is correct if you had 4 apps all interconnected and related to each-other with cross app relationships adding a 5th app with a cross app relationship with one of them would cause that app to become dependent as well. At its core the reason this is happening is that by creating the cross app relationship you are letting your app know it is dependent on that other app for data you want to either be sharing with or bringing over from the other app. To make sure the data your app has is correct it needs to wake up any other related apps and share data with it in the server. When that happens if that app is related to other apps directly it repeats the same process loading them all into the same server to share data. In instances of one or two apps becoming dependent on another app impact is minimal but if you keep relating apps you have more apps that are sharing the limited resources of a server.
Functions like Quickbase Sync, Pipelines, Automations, etc. were designed to avoid causing this entanglement and are often the tools we suggest when a builder needs to disconnect their apps but have them share data. A single table can become the source of truth across apps via Sync or Pipelines and then fed across apps as needed so that they do not need to be directly related and can continue to move as needed for resource balancing. The guide talks a bit about methods to avoid this and why it is beneficial and in cases where you need help our Care team can often help you identify interdependent apps.
------------------------------
Evan Martinez
------------------------------
That is correct if you had 4 apps all interconnected and related to each-other with cross app relationships adding a 5th app with a cross app relationship with one of them would cause that app to become dependent as well. At its core the reason this is happening is that by creating the cross app relationship you are letting your app know it is dependent on that other app for data you want to either be sharing with or bringing over from the other app. To make sure the data your app has is correct it needs to wake up any other related apps and share data with it in the server. When that happens if that app is related to other apps directly it repeats the same process loading them all into the same server to share data. In instances of one or two apps becoming dependent on another app impact is minimal but if you keep relating apps you have more apps that are sharing the limited resources of a server.
Functions like Quickbase Sync, Pipelines, Automations, etc. were designed to avoid causing this entanglement and are often the tools we suggest when a builder needs to disconnect their apps but have them share data. A single table can become the source of truth across apps via Sync or Pipelines and then fed across apps as needed so that they do not need to be directly related and can continue to move as needed for resource balancing. The guide talks a bit about methods to avoid this and why it is beneficial and in cases where you need help our Care team can often help you identify interdependent apps.
------------------------------
Evan Martinez
------------------------------
Do the new formula queries create dependencies, the way a report link would?
------------------------------
Michael Tamoush
------------------------------
------------------------------
Michael Tamoush
------------------------------
- MarkShnier__You
Qrew Legend
They have not said if they will Create Dependencies but at this time a Formula Query is limited to the single app. No Cross App Queries are allowed, yet.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
