I would like to use Obsidian and dataview to track my workouts and exercise progression. I have read this post, but would like to do something “simpler” with more flexibility.
I was thinking something along the lines of having exercise notes and workout notes. The exercise notes keep track of a single exercise and would use dataview to query the repetitions achieved from the latest workout notes. The workout notes (which I would manually generate the night before) would have a list of exercises (linked to their respective exercise notes) that I am planning to perform along with some goal repetitions etc. During the workout I would fill out the repetitions achieved.
The issue I am coming up against is trying to figure out a method of the exercises querying their repetitions from the workout notes.
I was initially thinking something along the lines of this for the workout note:
workout_date:: 2021-09-16 tags:: #fitness/workout # Title ## Warm up etc... ## Strength [[link-to-exercise-1]]:: 5, 6, 7 [[link-to-exercise-2]]:: 4, 4, 5
In the exercise note I was then thinking that I would be able to query by the title of the note. e.g.
```dataview TABLE workout_date AS "Date", this.file.name AS "Reps" FROM #fitness/workout SORT workout_date DESC
- The first and foremost problem is that it doesn’t seem like one can use a link for a dataview annotation key.
- The second problem is that I just want the exercise dataview query to only list values for its “own” reps.
I am pretty sure that there is an easier way to do this that I am not seeing. Does anyone have any suggestions?