I want to make a lesson schedule for students, so that I enter data for each student in the Users table, and then they have the opportunity to view this schedule personally
How long is the schedule gonna run for? Say some months? Do they actually need to look at it as a calendar, or a list would do?
I want to make it so that teachers can set a schedule for students, and students can review it, but the schedule must be repeated every week for six months
I think an alternative approach for you is to have two tables:
Schedules
| RowID | Student ID | Available from | Available until |
|---|---|---|---|
| S001 | ST001 | July 4, 2024 | January 4, 2025 |
| S002 | ST002 | July 10, 2024 | January 10, 2025 |
Schedule Lines
| Schedule ID | Day of week | Time start | Time end | Subject |
|---|---|---|---|---|
| S001 | Monday | 09:00 AM | 09:45 AM | Maths |
| S002 | Monday | 09:50 AM | 11:00 AM | Literature |
Then display the “Schedule” row to the user when “now” is on or after “Available from” and is also on or before “Available until”.
Upon clicking the schedule, they can see a list of subjects, grouped by each day, sorted by time start.
2 Likes
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.