I am building a coaching platform on Bubble where users can book coaching programs with coaches.
My current structure is :
Users
[…]
Rôle : User, Coach, Admin
Coaching program (only filled for Coaches)
Coaching Program
[…]
Coach (User)
Session list
** Session**
[…]
Coaching program
I wonder what would be the best way to store the followup. Each user can enroll into many programs at a various stage of session. I want users be able to know which coaching program they have enrolled, which session is pending, and mark as complete a session even if it’s no the previous / next one.
I was thinking of creating inside User : Enrolled coaching program
Coaching Program
Start Date
Pending coaching sessions
Session
Finished coaching session
Session
So if I need to see in an Enrolled Coaching Program which session is pending I just need to compare Coaching Program > Session with Pending Coaching Session or Finished Coaching session
It can’t be : pending, finished because users need to know which sessions inside the program are finished or not. Like a courses : I’ve read the first modules.
And I can’t say status is a number (ex 3 to say the first two are finished) because since the enrolment, the coach might update the list of sessions which will be reflected to the pending enrolments. So I guess I need to say Session ID is finished.
That’s why I was thinking of having Finished sessions - List of sessions inside the list Enrolled programs.