Many to many relationship with extra fields

Questions and Answers
2

Hello @Andrea_Cardinale,

From what I understand, you don’t want to create a 3rd collection type just to keep track of the progress, but it is impossible to be achieved this without storing it somewhere.

I would recommend structuring it like this

Collection Types:

  • User (relations: many-to-many with Courses, one-to-many with User Progress)
  • Course (relations: many-to-many with Courses)
  • User Progress (relation: has one course, has one user)

Lifecycles:

  • When you create a relation between User and Course, you should also create the User Progress, and attach the User and Course to User Progress.
  • When the user completes the course, you should modify the User Progress and change the status from enrolled to completed.
  • When you fetch the User with courses, you should also fetch the data from User Progress, by filtering User & Course)