Hi!
I am just starting to set up Airtable.
In a base, I have a contacts table and an interaction table - here is roughly how they are set up. I want to be able to convert a list of external email addresses to linked contact names in one cell.
Contacts
Name | Email | Interactions (linked)
Interactions
Interaction name | Date | Contact names (linked) | Notes
I sent an email to about 50 contacts, and want to input a row in the interaction table as follows:
Interactions
Intro email #1 | Jan 25th | (Name 1), (Name 2), etc | Description of email
Is it possible to fill in those names in the cell by copy and pasting a list of the email addresses I sent the campaign to, having airtable match those emails to the contact names, and then filling the cell with those contact names?