How do I link the tables in a base

[Joachim]

Good day!
I need your help with linking tables in a base.
I would like to link the tables here via the “Content ID” and get the “Content Title” and “Publish Date” (green) directly.
Unfortunately I do not get the column “Content ID” (yellow) when comparing the columns.
Thank you in advance, Joachim

[rdb]

Content ID is the link column. You cannot use the link column in the matching rule.

Reminder: When there is a match, a link will be created in the link column. If you could add the link column to the matching rule, this would defeat the purpose.

[bennhatton]

Hi Joachim,

I can see two options for your problem:

1. Create a new column Content ID text (formula type) with this simple formula: {Content ID} & "". Doing so, the Content ID text will reproduce the content of your {Content ID} column, and you will be able to use Content ID text in your data processing
2. Even easier to me (but maybe I don’t really understand your use case and this option is not possible for you): modify your Content Title and Publish Date column to link formula / lookup type, so they will update automatically when linking to a Content ID without needing to run your data processing operation (see below)
   
   

Hope this helps…

Bests,
Benjamin

[Joachim]

Thank you Benjamin, I forgot the Link formular! Joachim

[Joachim]

Is it possible that if I add a row in one table, this is automatically done in the others as well? The key is always the “Content ID”

[bennhatton]

Hi Joachim,
Unfortunately it doesn’t seem obvious to me, particularly because automations (inside SeaTable or in n8n) don’t offer the column creation as a trigger, as far as I know… You could eventually create a script to automate the creation of the lookup columns in the other tables, but you’ll have to launch it manually…