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.