Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Create Email Lookup / List from Two Different Tables

219 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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