Correct structure for collections

Hi all,

I am planning to create a sport program calendar for our sports club. Therefore I created the following structure:

collection: courses

  • entries with general information about every course (e.g. yoga, badminton)
  • partial with times when course will take place (multiple for one course)

Example

  • Yoga
    • Monday, 5pm-6pm
    • Friday, 10am-11am
  • Badminton
    • Monday, 7pm-8:30pm
    • Tuesday, 6pm-8pm
    • Friday, 10am-12pm

The reason why I structures this way is that I will only maintain generell course information once. Now I would like to create a program table with the sorted results like:

  • Monday
    • 5pm-6pm, Yoga
    • 7pm-8:30pm, Badminton
  • Tuesday
    • 6pm-8pm, Badminton
  • Friday
    • 10am-11am, Yoga
    • 10am-12pm, Badminton

When using the collection courses I do not have access to the partial information to group/order.

Which is the right way to structure these data? Thanks for any help. I am using v2 of Statamic.

Steffen

>>>>>>> Unanswered <<<<<<<
2 Replies
2 Followers