Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Using Airtable as a database - groups with multiple drop down

Topic Labels: Data Views
847 1
cancel
Showing results for 
Search instead for 
Did you mean: 
ambermaitland
4 - Data Explorer
4 - Data Explorer

Hello everyone. I am using airtable as a database for participants in programs, and every time a student attends a program, we have to make a new record for them instead of being able to hold all the info in one line. 

The reason is because if I make the program field a multiple select drop down (which is linked to another sheet with program information), if I group by program, anyone who has multiple programs in their program field will not appear in the group. 

Is there a smart way around this? At the moment, when students have multiple entries we have a checkbox field for duplicate records. This is inefficient. 

1 Reply 1
ScottWorld
18 - Pluto
18 - Pluto

You will need to restructure your database as a many-to-many relationship, which means that you will be using 3 tables instead of 2 tables.

The 3rd table is a "join table", and you can learn more about this here: https://support.airtable.com/docs/understanding-linked-record-relationships-in-airtable

Then, you will do all of your grouping, sorting, and searching from the "join table".

p.s. If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting — ScottWorld