Skip to main content

Linking two existing cells to use lookup

  • January 12, 2022
  • 2 replies
  • 41 views

Hi Community,

I would like to do something rather simple however, I am struggling with linking tables.
I have an E-mail address column in table A and the same in table B.
All addresses from B are in A, but not all of A are in B.
Whenever a new record (including a 5-star rating column) is added in B, I would like to synch A such that the rating is reflected in a column there too. Thus, similar to VLOOKUP in Excel, when the e-mail addresses match, Airtable should pull the rating in B to A.

Any ideas?

2 replies

Databaser
Forum|alt.badge.img+25
  • Brainy
  • January 12, 2022

Hi @Carina_Tiedemann and welcome to the community!

You could use an automation for this.

Trigger: when a records matches conditions
Action: find records
Action: update record


Forum|alt.badge.img+17

Seems like having the records from both tables together in the same table would be a great idea. Why you don’t do it?