Create Email Lookup / List from Two Different Tables

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.

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