Sheets Add-on: Bathroom Sign Out
One of the early projects I coded was a bathroom sign out sheet for Google Sheets. I was surprised how many people liked the spreadsheet. Since I first coded the bathroom spreadsheet, Google Apps as added Add-ons. I have updated the sign out sheet to be an Add-on with some new upgraded features.
Join Beta Testers
By requesting to join the beta testing group you can permanently add this Add-on to your Add-on menu. Find the thread for the Add-on “Bathroom Check Out Sheet.” The first message contains a link to install from the Chrome webstore.
If you would rather just have a copy of the template, click here. Look for “Bathroom” in the Add-on menu.
After installing the Add-on you will be asked to authorize the script. You are giving YOURSELF permission to access your Google Apps. Because I have not gotten the code verified by Google they might give you a very scary warning. I did not code anything malicious, it only allows you to access your own Google Sheets and your own Gmail.
Look for tiny words that say “Advanced” rather than the big blue “Return to safety” button. Then below that will be a link to “Go to Bathroom (unsafe).” Click on it, it’s safe. It’s just telling you that Google has not approved it.
Open a spreadsheet and go to the Add-on menu and choose “Bathroom.” From the menu choose “Setup” to insert a new sheet into the spreadsheet that has the Time Out and Time In headers created.
I recommend that you go to the Add-on menu and choose “Sidebar” from the Bathroom menu. This allows students to simply click a button to check out and to check back in, thus avoiding using the Add-on menu each time.
Clicking the Check out button on the sidebar will prompt the student for their name. The date, time and students name is automatically placed on the spreadsheet.
When the student returns from the restroom they simply need to click the “Check In” button. This will add the date and time onto the spreadsheet.
Just as an added protection, the spreadsheet will automatically email the spreadsheet owner notifying them that a student has left for the bathroom. A second email is sent when the student returns from the restroom. The purpose of the email is to verify the date and time. If a student decides to be mischevious and edit the date and time you can refer to the email to show what the actual times were.
I recommend you set up a filter in your Gmail to have those emails skip the Inbox. You only need the emails if you need to verify against the information on the spreadsheet.
Make a New Spreadsheet
If you signed up to be a Beta tester the Add-on is permanently in your Add-on menu. You can make a new bathroom sign out sheet each week simply by creating a blank spreadsheet. You only needed to authorize the Add-on when you installed it, so next time it will be faster and easier. Use the Add-on menu in your new sheet to setup the Bathroom sheet and you are good to go.
Multiple Sign Outs
This sign out sheet does not account for multiple students being out of the room at the same time. The Check out and Check in button work on the “active sheet.” This means you can use the Add-on menu to choose “Setup” to create multiple tabs at the bottom.
If a student has checked out but not checked back in, the next student can check out and check back in on the other tab.