Kurt Kaiser

Video Thumbnail Kurt Kaiser Code Tutorial Room Reservation

Room Reservation System Using Google Apps Script

—

by

Kurt Kaiser
in , , ,

Need a room booking system for Google Calendar? Willing to learn a bit of code?

This program allows people to reserve meeting or study rooms using a Google Form. After the user hits submit, the program checks the corresponding calendar. If the room is already reserved at that time, the user receives an email asking them to reschedule. If the room is available, the user receives a message detailing and confirming their reservation.

However, the program is not limited to rooms. In the past, I have used this as a reservation system for seventeen different laptop carts. This application can be used for any item that needs to be reserved and scheduled. The program is flexible and easy to scale up, manage as many or few rooms as you desire.

The video tutorial below demonstrates how I built the program.

Want to copy, mock, edit, steal or praise my code? Feel free.

Comments

12 responses to “Room Reservation System Using Google Apps Script”

  1. Teresa Leung Avatar
    Teresa Leung

    Hi… This is Teresa from Hong Kong.
    I found your script and tutorial very useful. Thanks a lot.
    However, I encounter one problem. The start time input thro the google form and the time output to the calendar is different. i.e. the user inputs 0900 as the start time on google form but it shows 0854 when output to the google calendar. I don’t know how to fix it. Is it a matter of timezone? Many thanks.

    Reply
    1. Kurt Kaiser Avatar
      Kurt Kaiser

      Hmm, do you mean it is off by minutes? Timezones would be hours, not minutes.

      Care to share the functions for request and end time?

      Reply
      1. Kurt Kaiser Avatar
        Kurt Kaiser

        Hello! The end time function is posted in the code on this page. Is it not showing up for you?

        Reply
        1. Itzel Chairez Avatar
          Itzel Chairez

          Hello Kurt,
          Thank you so much for taking the time to make this website! It has made all the difference! I am also having trouble with the time variable. How do we modify it to 30 min slots and or making it open ended?

          Reply
          1. Kurt Kaiser Avatar
            Kurt Kaiser

            You would have to change it in several spots. I would do a find and look for 20, or whatever number you want to replace and just change all those to 30. I think I walk through each variable in the video.

  2. Thomas Rose Avatar
    Thomas Rose

    Hi,

    I am trying to replicate your system in my school. Did you have to create the calendar first before? If so which MIS do you use and how did you pull the timetable data down? I have been on this project a while now. Any information would be amazing.

    thanks
    Thomas Rose
    Head of Ict and Computer Science Ysgol Gyfun Gwynllyw

    Reply
    1. Kurt Kaiser Avatar
      Kurt Kaiser

      Yes. I created the necessary calendars before. Time should be set by timezone of the owners account, or the timezone they selected for that calendar.

      Reply
  3. Sano K Avatar
    Sano K

    Hello! This is Sano from Korea. Your youtube video is extremely useful and I am extremely happy to use your code. I really appreciate it. It works perfectly well with our community. I just have one question. Is there a way to cancel the reservation by the person who made the reservation?

    Reply
    1. Kurt Kaiser Avatar
      Kurt Kaiser

      I have made a form that allows a submission for deletion. You can somewhat reverse engineer the code. However, I haven’t done this recently. If you mean from deleting it directly on the Google Calendar, I haven’t done. I think that can only done by the account owner.

      Reply
  4. Steven Avatar
    Steven

    Hello Kurt, I just saw your video and it is a godsend! I am trying to create a room reservation system so thank you very much for making this video. Is there a way to have an administrator approve or deny the reservation requests? I know a little bit of code if you can guide me… thanks for your help

    Reply
    1. Kurt Kaiser Avatar
      Kurt Kaiser

      Yes! I actually did a tutorial on a program for that. Check out this link: https://youtu.be/Ysmoi7L32fY

      Reply
      1. Steven Avatar
        Steven

        Thank you so much for the link, Kurt! It’s exactly what I needed. You’re the man!

        Reply

Leave a Reply

Your email address will not be published. Required fields are marked *