Best way to share schedules between users?

Ask for Help
1

Hi all,

I’m building a scheduling app for private teachers.

Each teacher creates their classes in a Classes table (with row owners) and adds timeslots in a Class Schedule table (also with row owners).

A common request: Teachers want to see each other’s weekly schedules so they can avoid clashes and coordinate better.

What’s the best way to implement this? I imagine the setup might be similar to public profiles, but:

  • How can a teacher share their schedule only with specific people (e.g. other teachers they collaborate with)?

  • And what’s the best way to display these shared schedules, e.g. calendar view, table?

Thanks a lot in advance!

1 Like
2

Hey Christo

To enable teachers to share their schedules with specific collaborators, create a “Collaborators” table with columns: Teacher and Collaborator (Email), and set Collaborator as a row owner. Relate this to the Class Schedule table using the teacher’s email. This allows each teacher to see their own schedule + plus any shared with them.

Use a Calendar view for a clear weekly layout, or a Table view for a compact list. Let teachers add or remove collaborators using a form or an editable list to manage sharing.

Hope this helps!

3

Hey Mazen,

Thank you for your reply.

I’m not sure how what you suggested would work. For example, if the “Class Schedule” tables looks like this:

Teacher Email (Row Owner) Day Start Time End Time
x@x.com Monday 15:00 16:00
x@x.com Tuesday 15:00 16:00
y@y.com Monday 17:00 18:00
y@y.com Tuesday 17:00 18:00

And the new tables “Collaborators” looks like this:

Teacher Email Collaborator Email (Row Owner) Class Schedule Relation on Teacher Email
x@x.com y@y.com Empty

The relation will return an empty result since the “Class Schedule” table has row owner on the teacher email.

What am I missing? Did I understand something wrong?

1 Like
4

Are row owners absolutely necessary to securely protect data, or are you simply using row owners as a filter? For something like this, I would think maybe row owners aren’t necessary, but I don’t know for your situation. I would think a filter would be sufficient. Unless you are using row owners to reduce the amount of data that is downloaded to a user’s device.

3 Likes
5

Hey Jeff,

Thank you for your reply. I was using row owners for filtering but after removing them the relationship works! Pretty straight forward answer but it helped :slight_smile:

2 Likes
6

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