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.