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.
