r/Notion • u/Bitter_Buy7856 • 7d ago
Questions Physiotherapy database
Hi everyone,
I want to make a workflow in Notion with exercises that I can give to my patients. I now have:
- Database with all the exercises
- Database with selected exercises per patient
- Database with the complete program per patient
Those are all linked. I would like to be able to print in gallery view, with the image of the exercise as cover. But I use a rollup for the image and I've read that it's not possible to make a rollup that cover image. I don't want to add the image by hand, that's why I have the central database. Is there any option to be able to make a program with clear images and all the info (like instruction, repetitions, etc.).
Thanks!
1
u/Thomas_yang1 5d ago
i'd probably drop the middle database. keep one exercises db, then on each patient program add a relation to exercises and a linked view filtered to that program. sets/reps per patient is the only tricky part, that's where a small join db makes sense
1
u/3dmindnet 4d ago
Rollups can't be used as a gallery cover, but a rollup of a Files & media property can still be shown as a card property, so the image appears on the card without re-uploading it. Keep the image in a Files & media property on each exercise in the central database. Since sets and reps differ for every patient, I'd add a "Program items" database: one row per exercise per patient, with a relation to the exercise plus Sets, Reps and Notes properties. Then make a gallery of it filtered to one patient, show the rollup image, instructions, sets and reps as card properties, and print that view.
1
u/sunbleached101 2d ago
I actually tried building this because I got curious if there was a workaround too.
I managed to make it work using just two databases instead of the three in your original setup:
Exercise Library – Stores all exercises and images. Add a separate Text property for each patient (e.g. Patient A, Patient B). Manually enter their sets, reps, and assigned days for each exercise.
Patients Database – Create a page for each patient and add a linked view of the Exercise Library. Set it to Gallery View, filter by that patient's property (e.g. Patient A is not empty), and display the property on the cards.
You can also add another filter for the day (e.g. Patient A contains "Monday") to show only that day's exercises.
This way, each patient gets their own Gallery View with the original exercise images and personalized instructions, without duplicating anything.
The downside is that you'll need a separate Text property for each patient, so this works best with a manageable number of patients. If that's too much of a hassle, then you might have no choice but to upload the images separately.
Heres a link to my test page: Physiotherapy Database
2
u/SellOnQuay 7d ago
One thing I’d try is a linked gallery view of the central Exercises database on the program page, instead of asking the rollup to become the gallery cover. Keep the image in a Files & media property on each canonical exercise page, set the gallery’s card preview to that property, and show instruction/reps as visible card properties. If your existing relations let the view filter to the exercises selected for that patient/program, the image stays in one place and no one has to re-upload it. I’d test the relation filter on a duplicate program first; one tiny Notion filter mismatch can make a perfectly good exercise disappear like it owes you money.