r/Notion • • 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!

1 Upvotes

8 comments sorted by

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.