Google Forms Sign Up Sheet Time Slots

Creating a Sign Up Sheet Page 6 of 6 the time slot they want to reserve. As time slots are reserved, the button for that slot will be replaced by a solid block with the name of the range in it. In addition, when a student reserves a time slot, Google automatically copies the reservation as an event on the student's calendar. Invite your participants to view and sign up on your signup sheet. They'll sign up on your sheet with their name and email information, no registration required. Need to round up volunteers for your service project? Make a sheet with volunteer roles and time slots.

The daily timesheet template is ideal for tracking how employees, freelancers, and contractors spend their time on a day-to-day basis. Filling in a daily timesheet couldn’t be easier – users are able to log their activities in half-hour time slots. Just enter an hourly rate and fill in the blanks. Get Daily timesheet. Google Forms is a free survey tool that’s part of G Suite—Google’s complete office suite (although some people refer to it all as Google Docs). The other main services included in the cloud-based suite are Sheets (Excel), Docs (Word), and Slides (PowerPoint).

First, I need to credit the idea behind this post to my son’s amazing fourth grade teacher. He figured it out first. I liked it so much as a parent that I stole it to use for our classroom.

The vast majority of the communication with parents at our school happens via email. Most teachers email their newsletters. Room parents plan parties through email and the administration sends out their information this way too. We are fortunate to be part of a community where we can be pretty confident that all of the parents have internet access on a regular basis. This works beautifully most of the time. I think parents are better informed and feel more connected to the school as a result of this electronic communication.

Google forms sign up sheet time slots vegas world

There is really only one time when doing things by email seems to bog us down, and that’s when it’s time to ask for parent volunteers. Another of the great things about our school is the way that the parents here are so generous with their time and money. People are quick to offer to lend a hand or send in donated supplies. I’ve seen sign up sheets for class parties fill up within hours because parents are so willing to help. Where it gets tricky is when an initial emailed request for help results in 25 “reply all” emails with parents offering their time and supplies. Again, it’s fabulous to be part of a group of such generous people, but scrolling through 25 emails to figure out whether or not the need for 30 plastic forks has been covered or not can try the patience of the best of us. This is why I was so thrilled when the last time my son’s teacher put out a call for donations, he created a shared Google document that allowed parents to sign up on a “live” sign up sheet. All of the parents could see the sign up sheet and as each parent added his or her contribution, that would be updated on every other parents’ sign up sheet. To see if someone had offered to bring in forks, I simply had to scroll down to the box next to “Forks” and see if there was a name by it. It worked so well as a parent that I used the system the next time our class was soliciting donations. It was equally easy to use on the teacher end of things.

Here’s how you can set up an online sign up sheet:

First you’ll need to sign into your Google account. Next, click on “Drive.” The screen you see will look something like this:

Next you’ll click on the orange “CREATE” button and select the type of document you want to create. A spreadsheet is often good for sign up lists, but you can create a regular document as well. I’m going to create a spreadsheet. Your sign up list doesn’t need to be particularly complicated. A two column sheet like the one I created is often good enough.

I created the list of needed items, and added my name so that parents would know where to sign up. There’s plenty of room to make this more fancy. Another, perhaps nicer looking option is to make a table using the “documents” rather than a spreadsheet. I’ve done it both ways and neither seemed too complicated for our parents to handle. One of the great things about using Google Drive is that it saves everything as you go, so there was no need to “save” this document to a specific place. What I did need to do though, was to “Share” this document. “Sharing” the document is the way that all of the parents in my class will be able to see it. To do this, click on the “Share” button in the upper right corner. When you do, the following box will pop up:

Go to the area of the box that says Who Has Access and below that, “Private.” Click on the link that says “Change…”

Google Forms Sign Up Sheet Time Slots Free

There, another box will pop up that says “sharing settings.” Choose the option that says, “Anyone with the link.”

Google Forms Sign Up Sheet Time Slots Online

Finally, and this part is key, find the part that says Access : Anyone (no sign in required) Can View

Click on “Can view” to see the drop down menu and choose “can edit” this will allow your parents to edit the document that you are sharing with them. It’s the part that lets them add their name to your sign up sheet.

Google Forms Sign Up Sheet Time Slots Vegas World

Once you’ve made that change, click on save to return to this window:

Copy the “link to share.” (I blacked out part of my link for privacy reasons.) This is the link that you will paste into your email when you tell people where to go to sign up.

Google Forms Sign Up Sheet Time Slots Bonus

The rest is easy! Simply draft an email to your parents giving them the link to your document and ask them to click on the link to add their name to the sign up sheet. You can monitor the sign up sheet from your own Google account and see how well needs are being met. We sent out a second email with the link as a reminder to parents the day before we needed the items they had signed up for. **Quick note for anyone from my school who happens to be reading this: Copying and Pasting the link with our school’s main email system did not work for me. I had to paste the link into my gmail account and then forward that to our main email system.

Really, there are so many uses for this little trick. Even if all of your parents aren’t on email, all of your teachers probably are. You can use this technique with teachers to sign up for things too. A soccer coach could also do a snack sign up sheet this way. I’ve played around with a number of other computer sign up systems. There are several online. Google “Digital Sign Up Sheet” and you’ll get plenty of hits. What I like about using Google drive to do this, is the simplicity. No one has to sign in with their name and email address each time. I as the teacher don’t have to enter everyone’s email address. I simply make a document, share it with my intended recipients, and I’m done!

Give it a try. You will love how much simpler this makes your life!