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.