I’m creating a platform service that allows teachers and students to match freely in music learning.
When students select a teacher, I would like to create a format that allows students to select a date and time from the date and times that the teacher can give lesson.
(The format is similar to the screenshot below. The date and time are displayed in calendar format. ○ is displayed when the teacher can give lesson and × is displayed when the teacher cannot. Students can choose only the date and time ○ displayed, and, when students choose a date and time, text and number that read the date and time are showed.)
On the teacher side, I would like to be able to register separately for the regular schedule and irregular schedule. The regular schedule is a basic schedule that teacher give lesson every week. Teacher decides this schedule like below.
“Sunday 18:00-20:00
Monday 13:00-16:00
Tuesday none”
When teacher want to give lesson on a date and time different from the regular schedule, he or she can set irregular schedule. I would like to create format that teacher can change their schedule on the same calendar format students choose.
Is these schedule management method possible?
Since I’m a beginner in bubble, I don’t know how to handle database.
Even if it’s impossible to implement everything, I’d be very grateful if you could just tell me the method to create something similar.