While I have known about Airtable for several years, I recently became independent and am looking to use Airtable to organize my new company, as well as projects in my personal life. It looks like a great and very useful tool.
I started learning classical guitar a few years ago, and see that Airtable could be a great tool to replace past efforts - especially if I can get the forms working right. This is where I am having trouble.
This is the structure of the course (big to small):
- Grade (currently 8 grades)
- Unit (20 units, typically 2~3 units per grade)
- Lesson (approximately 10 lessons per unit)
- Exercise (approximately 10 exercises per lesson)
- Each exercise is done at tempo for a certain number of times, and I may do the same exercise several times at different tempos.
I also created tables that contain Scales, Technical Routines, and Performance pieces. Naturally, there is some overlap with some lesson exercises and scales.
I want to be able to create a form, where you will choose the grade, unit, and lesson, and then be able to put in the exercises and different tempos. I think it would be better to choose this from the Lesson form. However, I cannot get the other information to show easily.
I have watched a few videos on YouTube, and am fairly competent with Google docs and other spreadsheet programs. I also looked in the Airtable Universe and Template libraries for a similar function (similar to an exercise log (upper body --> chest --> bench press --> 3 sets, 10 reps, 50kg). Even the Pocket Gym template is close to what I am looking for, but misses the mark. The log file shows different exercises on different dates, but does not fully connect the two. The user is putting the weights and sets in notes - not in the columns for weight, reps, and sets…
Any advice or pointers would be highly appreciated. Thank you!