Home » Google » Apps » Apps Script » Bathroom Sign Out Sheet Template

Bathroom Sign Out Sheet Template

Bathroom Sign Out (2)

I had a friend using a Google Sheets spreadsheet to have students sign out and in for the bathroom instead of the paper sign out. The problem became the amount of scrolling after many students had signed out. I created a template to help with this.

The Template

http://tinyurl.com/bathroomsignout

Bathroom Menu

After making a copy of the template look for the “Bathroom” menu near the “Help” menu.
bathroom menu

The menu has 3 options: Check Out, Check In, and Sort.
Menu bathroom

Check Out

When students sign out for the bathroom they select an empty cell in column A. Using the “Bathroom” menu, the student chooses “Check Out.” This will place the date and time into the cell. The student would then put their period and name into columns C and D.
Bathroom sign out and in

Check In

When students return from the bathroom they select the cell in column B. Again using the “Bathroom” menu, the student chooses “Check In.” This places the date and time of the students return in column B.

Sort

Choosing “Sort” from the “Bathroom” menu sorts the entries in reverse order. Most recent at the top. This also inserts 10 rows at the top to give students room to sign out to the bathroom without having to scroll. Students can use the “Sort” option to insert more rows as well.
Sort Bathroom Entries

 

Update

Apparently the spreadsheet defaults to the west coast where I live. This is a Google Sheets setting, not something in my code. CLICK HERE to change your Google Sheets settings to your local time zone.

Digiprove sealCopyright secured by Digiprove © 2015

18 thoughts on “Bathroom Sign Out Sheet Template”

  1. I do a bathroom checkout via forms, so the students don’t have to navigate cells and scrolling. They just fill in a few boxes. When needed I can look at the spreadsheet, and even filter each kid into a separate tab using rowCall.

  2. Pingback: Bathroom Sign Out Sheet Template | Teacher Tech @a… | EducatorAl's Tweets

  3. Great template but I am not getting the correct time. I’m eastern time zone with the correct time displayed on my computer but the check out/in times are 3 hours off. Suggestions?

  4. Pingback: 09-2015-10-22 CI100 – FIELD TRIP | CSUF CI 100 Keeler

    1. Love this sign in/sign out sheet. I customized it for our kids, adding a destination column, and changing the name from bathroom to Sign in/Sign out sheet. I had to change the time formatting because it always posted military time. Easy fix under Format/More Formats/More date/Time Formats. Also, the librarian and I often have kids going back and forth. We have the sheet shared and open at the same time and can see who should be on his way from one place to the other. Awesome! Thanks so much!

  5. I made some changes in the template, adding a column for destination and changing the sheet to “Sign In/Sign Out” so it could be used in many situations. I had some trouble with the time showing up as military time. I fixed this by going to Format/Numbers/More Format/More Date Time Formats. Perfect fix. Love the form. Thanks!

  6. Pingback: Bathroom Sign Out Sheet - Teacher Tech

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.