Thank you so much for taking time to have a look at my problem. I have used Webflow’s dynamic CMS in the past, and I am familiar with how it works. I’ll try to be as detailed as possible as to what my client is wanting.
They run a music school and each teacher (the employee) as a certain number of students per day that take thirty minute time slots each. Lets say a proxy name of Dave is one of the teachers and he teaches Jack, Jan, Jinny, and James on Monday for thirty minutes each form 2pm - 4pm. Then on Wednesday, Dave teaches Tim, Tom, and Tammy from 1:30 pm to 3pm, then he has a thirty minute break to 3:30pm, and then he teaches Adam, Amy, and Allan form 3:30pm to 5pm.
Each student listed on the schedule needs to have their name and the instrument they take. The teachers schedules have availability each day (Mon - Sat) from 9am to 9pm (8:30pm - 9pm is the last available time slot). If you segment each time slot for one day, that is 24 slots. Multiply that by 5 for each day and you’ve got 120.
So, if I start to put this together, I have a CMS for each teacher, but because there is a limit of 30 fields for Webflow CMS, I can’t just put all of the available time slots they have there. So then I need to create a 26 field (24 for each time slot, 1 for the day of the week, and one reference field for the teacher it belongs to) CMS for the days that they work that points back to its corresponding teacher. However, because I need the student’s name, time, and instrument, Those 25 fields in the CMS accounting for days need to be reference fields pointing to yet another CMS for each student. However, you can’t have 25 reference fields. You can only have 5.
If I take a different approach. I can have a CMS for the teachers, and another CMS for the students. The teacher’s CMS would just be their name. The student’s CMS would be their name, instrument, teacher, day, and time. Then I would go to the teacher’s dynamic page and style it with a static schedule with empty slots and fill each of those slots with individual collection lists and do some crazy filtering. But this solution will require a lot of code and keeping up with the students enrolled, student time changes, and student cancelations gets very confusing and tedious for my client.
I think my approach is just all off if I am going to solve this problem dynamically with CMS. So sorry for the supper long response. Just trying to take you through my thought process so you can see my errors. Again, thank you to anyone taking time our of your day to try and help me with this. I’m just completely stuck…