Is there a way to connect 2 CODA documents?

[Asaf_Moses]

hi Tatiana, how were you able to achieve this?

[Tatiana_Ponomareva]

Hello! I did everything according to the instructions Is there a way to connect 2 CODA documents?
then instead of table names, put their ID, added a command that gives the name of the source document in a separate column and everything turned out )

The screenshot shows the required columns for my script.
You can also add other columns that you go to see. Their names should coincide with the names of the columns in the source tables.

[Alana_Zimmer]

hey @Tatiana_Ponomareva how did you include the source table name? can you forward the code that you used? thanks!!

[william_melatini]

+1 my vote for “accross doc relationship” feature:)

[Paul_Danyliuk]

I’m currently working on a setup where there’s one admin doc (data source) and N individual docs (user dashboards), and I’m propagating changes using Zapier. It’s possible given that N individual docs are copies of one template doc, plus some Paul’s Signature Magic™ with helper tables, buttons, and automations.

I’ll make a write-up as soon as I have time for that

[Hamad_Alhomaizi]

even Airtable has this problem with the inability to pull from one Base to another

[Sayantan_Chaudhuri]

Apologies for this redundant comment, but after duplicating a common dataset between three documents, setting up all local references after the fact, and then manually updating everything for a handful of new additions today, even with the new copy-paste functionality, I just had to come here and add that this feature cannot come fast enough

[cnr]

Would love to know the best way to do this. I’m going to take a look at the API, but that requires a lot more work on my part than I’m really interested in doing.

Basically, I just want to be able to run Coda::GetDoc(MyDoc).TableName and then have all the nice features that I would expect when operating on a table (Coda::GetDoc(MyDoc).TableName.Filter()` etc.

If that means I need to ‘import’ the doc first (with a coda pack or whatever) for performance reasons I’m fine doing that. It’s just generally the case that I like to have multiple tabs open with relatively small, focused apps running in each tab, but then I want to reference the data of each of those tabs from the other apps.

I know this is really just a rehash of what others have said, but this thread needs another boost

@Paul_Danyliuk I look forward to your writeup.

[BJL]

Thanks for boosting this, @cnr.

An import pack would be an easier, better solution than Zapier.

@Paul_Danyliuk , I am interested in your write up – I think I know what you’re doing, though.

[Paul_Danyliuk]

All and @cnr and @BJL,

Just recorded a video tutorial on that:

[Video] Sync data changes from one doc to multiple docs (e.g., admin → individual users' docs)

In this video tutorial you’ll learn how to set up a system where data changes in one doc (e.g. Admin panel) are propagated to multiple individual docs (e.g. user dashboards) using a free Zapier plan. As an example, I’m building a freelancer’s task tracker where I’m logging tasks for different clients, and those changes are then synced to every client’s individual dashboard doc. This multi-doc setup is a workaround for the fact that Coda doesn’t have granular permissions yet. It allows to make s…

[BenDavis]

This may be of interest to you all: Sign up for Beta access to…Data from another doc AKA Coda Doc Pack

@alex @Ocean_School_Ecole_des_oceans @Philip_Johnson

[alex]

Ayyyy! Yesssss!

Thank you so much!

[Philip_Johnson]

Thanks @BenDavis!

Excited to give this a spin!