# How to make a lesson schedule so that students can't edit the schedule, but it repeats every week

**URL:** <https://community.glideapps.com/t/how-to-make-a-lesson-schedule-so-that-students-cant-edit-the-schedule-but-it-repeats-every-week/74568>\
**Category:** Ask for Help\
**Created:** [July 2, 2024, 7:53pm UTC](https://community.glideapps.com/t/how-to-make-a-lesson-schedule-so-that-students-cant-edit-the-schedule-but-it-repeats-every-week/74568 "2024-07-02T19:53:41Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![mathandengschool2024](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mathandengschool2024/32/77187_2.png) [@mathandengschool2024](https://community.glideapps.com/u/mathandengschool2024)\
**Post date:** [July 2, 2024, 7:53pm UTC](https://community.glideapps.com/t/how-to-make-a-lesson-schedule-so-that-students-cant-edit-the-schedule-but-it-repeats-every-week/74568/1 "2024-07-02T19:53:41Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 2, 2024, 11:13pm UTC](https://community.glideapps.com/t/how-to-make-a-lesson-schedule-so-that-students-cant-edit-the-schedule-but-it-repeats-every-week/74568/2 "2024-07-02T23:13:50Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![mathandengschool2024](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mathandengschool2024/32/77187_2.png) [@mathandengschool2024](https://community.glideapps.com/u/mathandengschool2024)\
**Post date:** [July 3, 2024, 8:29am UTC](https://community.glideapps.com/t/how-to-make-a-lesson-schedule-so-that-students-cant-edit-the-schedule-but-it-repeats-every-week/74568/3 "2024-07-03T08:29:33Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 3, 2024, 11:17pm UTC](https://community.glideapps.com/t/how-to-make-a-lesson-schedule-so-that-students-cant-edit-the-schedule-but-it-repeats-every-week/74568/4 "2024-07-03T23:17:58Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [July 10, 2024, 11:18pm UTC](https://community.glideapps.com/t/how-to-make-a-lesson-schedule-so-that-students-cant-edit-the-schedule-but-it-repeats-every-week/74568/5 "2024-07-10T23:18:10Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.