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
May 30, 2021 01:37 PM
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!
Jun 01, 2021 12:24 AM
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.