CRM - converting email to contact name

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?

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.