This is totally doable in Airtable. I’ve done something very similar with teams within my org. Considering that each training probably has different criteria, this could be approached a few ways.
- Put all needed info into one table, then hide columns with Views. This is Airtable’s way of changing how the data appears and does not change the data.
- Put each type of training in separate tables. This may be a cleaner approach for your application.
I recommend putting students in a separate base, so their info is in one location and added when the student signs up.
Sync the student base with the training base, so instructors have a list of students. The draw back here is if instructors need to edit a students data. They would have to go into the student base to do that.
Evaluations could happen directly in the training base or submitted via Form.
Also, cool that its a diving club. I’m trying to get back into diving myself. If you want any further help, I’m happy to work with you on this.