Hey all, I manage a makerspace at a college and I’ve been using Airtable for about a year. It has really helped me organize the makerspace operations–especially keeping track of which users have completed training on the various equipment we have. My question today is about overall base design. I currently have one table that has user information: name, email, etc. and three columns for each piece of equipment: Date training completed, a link to the staff that gave the training, and a formula that shows whether the training has expired or not. We currently have 14 or 15 trainings, and the table is getting difficult to read. It just occurred to me to create another table for the trainings (or each of the trainings) and then link those to the “User information” table. This was one of my first bases and I pulled it in from a spreadsheet, so it behaves much more like a spreadsheet and less like a database.
@Julian_E_Post Thanks for the quick reply. I was thinking something similar to what you posted, but I’m conceptualizing the Equipment table as referring to the training module, rather than the actual equipment and the Trainings table as instances of that training (ie the date the training was given to the people). Maybe that makes the whole Equipment table redundant, though.
Here’s a link to a mockup of my current base: