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.
Hi Joachim,
I can see two options for your problem:
- Create a new column
Content ID text
(formula type) with this simple formula:{Content ID} & ""
. Doing so, theContent ID text
will reproduce the content of your{Content ID}
column, and you will be able to useContent ID text
in your data processing - 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
andPublish 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
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…
This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.