How to update an exercise (Reps /Weight)

Hi All

Great community here, i have a question which i would appreciate some help on

I have created an input button for where a user can input the number of reps or weight for each exercise but how would i go about saving this record so that the exercise is only updated for the specific user who has logged in, should i be adding the reps / weights property to the User Collection or the Exercise Collection ?

thanks Bernard295Clar k for your feedback, im a little stuck on the User Collection part

I have made all the exercises in a separate collection, iv also added reps and weight to the user collection. But how do i implement the structure so that when an update to the reps and weight , it is specific to that named exercise in the exercise collection ?

Thanks, hope that make sense

Hi @JimJim10,

One of the ways to do it is to use 3rd collection, let’s call it “ExAttempts”, and store attempt data there.
In Exercises you’ll store just the exercise itself (name, description, photo, etc…).
And you will need to link ExAttempts to Users (one user can have many), and to Exercises (one exercise can have many).
So when a User goes to the gym, they can create new ExAttempts: User is linked to logged-in User, Exercise needs to be selected from a list/dropdown. And then a user can enter details (nb of reps, weight, date and time, …).

I’ve explained the general approach, so details may vary.

Best,
Victor.