Create a formula to match values from two different tables

[Dean_Arnold]

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!

[Mohamed_Swella1]

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

[ScottWorld]

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.)

[Dean_Arnold]

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?

[ScottWorld]

Dean_Arnold:

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.