Skip to main content

This one has me stumped…


Please help!


I have two tables in my base.


Table A has a field called ‘Brand URL’

Table B also has a field called ‘Brand URL’


I would like a formula field to find matches between Table A and B based on their Brand URL values.


When a match is found, I would like to automatically link the records together.


What’s the best way to do this?


Thanks!

Hi @Dean_Arnold,


You cannot create such formula. HOWEVER, how about you change this Field into a Linked Field instead? Use this field to create a new Table, link both fields in both tables to this new table, then you can pull whatever data you want.


BR,

Mo

 

This can be done with either Airtable’s automations or with Make’s advanced automations for Airtable.

(You can also a one-time-only conversion of a field to a linked field, in which case Airtable will do a one-time automatic matching to the primary field only in the other table.)

Thanks! @Mohamed_Swellam , Unfortunately in my case, the brand URL field is not going to be unique, so I can’t use it as a primary field.


@ScottWorld Thanks! That is a bummer what you say. So it only works once? Could I not continually change the field from text to a linked record every time I wanted to make the connection?

Thanks! @Mohamed_Swellam , Unfortunately in my case, the brand URL field is not going to be unique, so I can’t use it as a primary field.


@ScottWorld Thanks! That is a bummer what you say. So it only works once? Could I not continually change the field from text to a linked record every time I wanted to make the connection?



Well, once your tables are linked based on that field, if URL remains the primary field in table #1, then matching URL’s in the linked URL field in table #2 will automatically & continually link from that point forward.

Reply


Terms & Conditions