Skip to main content

Hi! 

I work at a digital school and I would like to have an easy view where I can see all my classrooms whether they are booked with a course or not. I have a total of 20 classrooms. 

I already have calendars where I can put the dates, the courses and the classrooms the courses will be taught in. In the calendar view, I also created a returning view telling me whether a classroom is already booked. I have a tab with all my classrooms and another one telling me if there’s an error due to booking the same classroom for two courses at the same time. 

I also am able to create a view of all the classrooms that are booked but I don’t seem to be able to add the classrooms that are available. I’m sure there’s a way to add the empty classroom. 

Is there someone who can help me? 
Thank you :)

Could you provide some screenshots of your tables with some example data please?


Sure (sorry everything is in French)
This the calendar tab. “Salle” is Classroom and towards the right you have the booking status indicating the booking is ok or it’s already booked. 


This is a​​​​​the classrooms lists
 

 

And this is the log of all the classrooms that were booked


Hey ​@Leo Lyuki,

1. Can classrooms only be booked on fixed schedules? E.g. 1hs periods Monday to Friday? Or is this really flexible?

If fixed, you will want to make sure that under Calendar table you have one record per slot per classroom. If there is a reservation for such slot (linked) the slot becomes Booked, otherwise the slot is Available. (you can handle this with an IF() formula).

So rather than looking at availability from the Classrooms tables, you would do that from the Calendar table -as my understanding is that you do not need to know whether right now the classroom is booked or available, but to see and find available sports in the future. Right?

I hope this is not too confusing, please feel free to grab a slot using this link and we can go through it on a quick call. I’d be happy to help.

Mike, Consultant @ Automatic Nation


oh nice, I should have thought of that! 

You are right, I can process all that under the calendar table. My explanation was maybe a tad ambiguous (sorry my English is a bit rusty) but you got it. 

 

Thank you! I will try it on Monday and will come back to you :)


Sounds great ​@Leo Lyuki, feel free to reach out if you have any other question/need further help!

Mike, Consultant @ Automatic Nation 


Reply