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.
After making a copy of the template look for the “Bathroom” menu near the “Help” menu.
The menu has 3 options: Check Out, Check In, and Sort.
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.
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.
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.
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.
20 thoughts on “Bathroom Sign Out Sheet Template”
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.
How do you change the time stamp to other time zones?
Your computer dictates the computer clock. The script pulls from computer clock.
Forms are always the right answer for collecting data, the issue is signing back in.
This looks promising, but I’m not seeing the bathroom button next to HELP…do I have to enable something? Thanks, Matt
Does not work on tablets, sorry
Is there a way to change the word Bathroom for other check in/out options? Love this!
You can edit the Google Apps Script, yes. Go to Tools->Script Editor and change the name of the script.
Thanks so much! That is awesome!
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?
You have to set your Google Sheets timezone settings. It is not an issue with my script.
Thank you. That did it. I changed the Spreadsheet settings and it reflected the correct time now.
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!
On your form just use 2 check boxes one for exiting and one for entering. That will solve your signing back in issue.
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!
Is there a way to do this on the Ipad? I’ve tried using the template through the sheets app and google drive and the options at the top are not there. Thanks for your help!
Unfortunately no. Add-ons do not work on mobile devices.
You must log in to post a comment.