Help

How to setup 'Master' table to run query across multiple table data?

Topic Labels: Base design
782 1
cancel
Showing results for 
Search instead for 
Did you mean: 
donut89
4 - Data Explorer
4 - Data Explorer

Hello,

Referring to this Volunteer Management template:

Volunteer Management Template - Free to Use | Airtable

How can I combine all of the tables into one 'Master' type of table so that I can run queries across table fields?

I understand that there are lookup fields.  But each Volunteer Event has multiple Volunteers.  Each Volunteer can have multiple skills.  So if I want to run a query where I want to find out the pool of skills that the pool of volunteers bring to Volunteer Events between Sept 2023 and Octo 2023.  How would I construct the Master table (or some other method) to run such a query?

1 Reply 1
Arthur_Tutt
8 - Airtable Astronomer
8 - Airtable Astronomer

Hey @donut89 Great question! Here's a quick Loom Video to demonstrate how I'd go about setting up and linking the tables, and how I'd make a 'master' table to quarry the data. 

Table Structure:

Screenshot 2023-11-05 172208.png

 

Screenshot 2023-11-05 172223.png

 

Screenshot 2023-11-05 172235.png

 

Screenshot 2023-11-05 172247.png

 

 Let me know if that makes sense!