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.
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.