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!
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.