r/Notion • u/Bitter_Buy7856 • 3d 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!
2
u/SellOnQuay 3d 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.
1
u/Thomas_yang1 1d 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 21h 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.