Common Data Sets - Linking Records

[Jaffa]

I have a main base called “SOURCE” and a second base called “CQC”. Within SOURCE I have a table called “Sites” which is shared via a Common Dataset into CQC.

Within the CQC base, some more information is added that needs to be kept separate, but there is a single piece of information that we need to sync back into SOURCE - which Sites are linked to which Registration.

I have created a second Common Dataset in CQC and added that into the SOURCE base, such that I can see that data. However I would like to automatically link the Sites table to the new table but I seem to be unable to do this.

I am aware that Linked Records do not work across Common Datasets, so I have a rollup function that is looking up all RowIDs and putting them in a column. How can I then go about linking the data all together.

In the screenshot below I am looking to get the RowID is “Link Formula” into the linked field “Sites”

[rdb]

Common datasets only support unidirectional sync. That is a functional restriction.

@Jaffa

I have created a second Common Dataset in CQC and added that into the SOURCE base, such that I can see that data. However I would like to automatically link the Sites table to the new table but I seem to be unable to do this.

In the screenshot, I see a link column from CQC requirements to Sites. How does that related to your statement: “However, I would like to automatically link the Sites table to the new table […]”.

I personally would try to avoid this back-and-forth syncing. I see two options:

• Immediate solution: You write a Python script that copies the data from CQC into the Sites table in SOURCE.
• Mid-term solution: We are working on making links across bases possible. That could be a solution to your problem. We’ll probably release it in the second half of the year.