Create Email Lookup / List from Two Different Tables

446 0
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Folks:

Any structural advice would be helpful for this Airtable setup.

Table 1: List of Judges (Name, Email, etc.)
Table 2: List of Applications (Name, Email, etc.)
Table 3: List of Groups (Group 1, 2, 3. etc.) that is linked onto Table 1 & 2 for assignment. I can see, of course, who is then been assigned into a group, but it’s difficult for the viewer to just copy out the emails for contact.

QUESTION: How could I create a Table 4: Pulls it all together in a “Contact Sheet” for each group. I’d like a table that is sortable by Group but also allows the viewer to easily copy/paste emails out of. So, it would be a grid view.

Note, I would like to keep the Judge and Applicants’ information on separate tables vs. combining into one.

Thanks for the thoughts/advice.

0 Replies 0