Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Linking tables - not working

Topic Labels: Base design
372 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello. I have 2 tables, each with a list of names and email addresses and other information.
I am trying to link the tables such that table A will search for the same email address in Table B and then pull a related column from Table B into Table A. I have tried linking the columns, but it doesn’t produce my desired results. How do I do this?

thanks!

1 Reply 1

If you want to link by the field {Email Address}, {Email Address} has to be the primary (left-most) field of one of your tables. Say that’s Table B

For each record in Table A you have to enter the relevant email into the Link to another record-type field you created. Once Airtable knows which email to look for, you can use a Lookup or Rollup-type field to pull in information from Table B into Table A but only for the record you linked to.