This story starts with pain. The pain of using google sheets on mobile during a training session, to be specific. I wanted to find some easier way of browsing exercises, descriptions, repetitions, etc. while keeping all training history. Basically how to use google sheet functionality while not using google Sheets.
Here comes the Airtable. I think the first google result is quite accurate about it.
Airtable is a spreadsheet-database hybrid, with the features of a database but applied to a spreadsheet.
Seems nice? Let’s dive in.
I will show you the path from zooming in google Sheets between reps to an easily browsable airtable database.
For this example, I prepare a dummy training description in excel. They might not make any sense but this is not the point here.
FROM THIS
TO THIS
What do we want?
Let's look at the training and how they are specified. There are cycles that are X weeks long and consist of 3 different training sets. Training A, B, and C. Each training consists of other exercises. Worth to note is that some of the exercises are the same in different cycles.
- Cycles with three different pieces of training
- Training with exercises
- Exercises - I will live it as it is (long text). You can dive deeper and split it into series, repetitions, etc.
Airtable database and exercises table
First, go to airtable and create a database (in airtable terms it is a base). The first thing you will is a table called “Table 1” with some columns. Let’s remove them and call the table Exercise. The convention is to keep it singular so let's stick to Exercise instead of Exercises.
Also, we can change the name of the database on the left top. Let's call it MyTraining.
Based on exercises in google sheets, each exercise has some description and type. Those will be the two first columns in the table. Let’s use Long text
for the description and single select
for the field type.
Now add all exercises from google sheets to the table. Click +
button under the Name
column and fill in the values.
In the Name
column, I used a short description that briefly describes what it is about. It could be helpful when doing the same training for the n time in a row.
Exercises to Training units
Now let’s create the second table. All the exercises are grouped into training units in this case. To switch between them we need another table called Training
. It will represent your one day at the gym so it will consist of all the exercises you should do in a single session. Create one adding new card next to Exercise
- “Add or import” and choose “Create empty table”.
Remove all unnecessary fields and add a new column. This time it will be a relation column called Exercises
. Choose “Link to another record” and “Exercise”. Check if “Allow linking to multiple records” is enabled.
Let’s create our first training. For the name, I will use the A
B
C
keys since that is the way I have them ordered in the google sheets on the cycle level. Previously created exercises add based on what is in your google sheet.
You should have sth like this at this moment.
Training to Cycles
Now let’s create the cycle table. All the training units are grouped into cycles in this case. To switch between them we need another table called Cycle
. Remove all unnecessary fields and add a new column. Again use the relation column called Training
. Choose “Link to another record” and “Training”. Check if “Allow linking to multiple records” is enabled.
Cycles are groups of training units in the scope of a few weeks. I. e. we have here: 3 training units N times each is one cycle. So to model that we will use the same technique as in the relation between exercises and training.
And fill the table row.
Going mobile
I found that using Airtable mobile app is very useful in this case. Download it on your phone and log in. Check what we’ve just created.
Cycle view
Trainings in cycle
Exercises in a training unit
Exercise details
Obviously, there are a few things that we can improve. The first is that we don’t need details like cycle and training on the Exercise details view. If we check the Exercise
table in airtable, we can see some new columns which we didn’t create. They were created automatically when adding a relation. Hide it to remove it from the view also on the mobile.
Right-click on the column name and choose “hide field”. Do the same for the Cycles
in the Training
table.
Another thing is that we can work on Training unit name to make it more meaningful.
First, let's move the training key to a new column. Choose the “select single” option and add A B and C options.
Second, retrieve the exercise type with the rollup field type. Add a new column, call it ExercisesTypes
, choose “Rollup” type, then the Exercises field and Type
as a field to roll up. The aggregation formula will be joining all types divided with slash into a single string.
ARRAYJOIN(values, "/" )
Next change the Name
field type to “Formula”. Right-click on the column name and choose “customize field type”
All this should result in the name: TrainingKey + types of exercises in training
.
Don’t forget to also hide columns TrainingKey
and ExercisesTypes
.
Let’s check again the mobile app.
Summary
This only shows how we can move from one tool to another which is easier to use in this case. Don’t forget that airtable is a much more powerful tool. A few example ideas of mine to extend what we’ve already done:
- Add a starting date to the cycle to sort them with the current one on the top.
- If you are a couch you can add a
User
table to manage training between them. - Create another table that will log the training you have done. Then you can generate a report for your coach every week. Also, you can automate it!
- You can add a field with a link to a youtube video on how to do certain exercises.
This post was originally published on my blog. Check out for more.
Top comments (0)