How do I link the tables in a base

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

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.

1 Like

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

1 Like

Thank you Benjamin, I forgot the Link formular! 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”

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…

1 Like

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.