+11This 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!
+17Hi @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
+35
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.)
+11Thanks! @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?
+35Thanks! @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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.