You are missing some Flash content that should appear here! Perhaps your browser cannot display it, or maybe it did not initialize correctly.

Notes

Limitations and caveats:

This system would break miserably if it were used in a situation where a rush of users were trying to access the same limited resource because it doesn't put a "lock" on the timeslot until after the form has been submitted.  

It also doesn't prevent the user from manually changing the prepopulated form values.

You could end up with a few extra signups for some slots, so I'd advise running your own manual checks if you are using this in mission critical settings.

All that said, it's a free signup tool that integrates into Google Docs.

Credits:

David Wees wrote the scripts that push columns from spreadsheet to spreadsheet.

Push my thinking

Please let me know if you implement and or modify this solution. I'd be curious to see how it gets used!

Useful links

Template for Public Side Spreadsheet
Template for Private Side Spreadsheet (contains scripts)
Link to Prezi showing the schema for how it works

Comments

mgns.nlssn
mgns.nlssn5 weeks 3 days ago

Arghh... I want it to work

Hello all!

First of all, thanks for a goldmine och cool scripts and functions for me to use in our School environment. I can't explain how lucky I am finding this site!

I do have techy issues though, the one that really is bugging me is the confirmation email that should be sent off when user Submit the form...

It looks all good in the "spreadsheet" but no Email is fired off, I've tried doing the trigger thing, but I think the backend system in Google has changed slightyl since you made the screencast. 

I read that I can take something from the AutoCrat scripts, but I don't understand how.

Help needed!

My testsite url: https://sites.google.com/a/gavle.engelska.se/rsss-devo/

What else is needed for anyone to help?

Thanks in advance!

frank55
frank556 weeks 16 hours ago

The system that they offer

The system that they offer here is so good. I see so many great benefit that come from using it here. I just love the great options that they offer. IT is a must to use. psychotherapy Toronto

ralesechti
ralesechti7 weeks 4 days ago

I researed valuable

I researed valuable information on this point as I am working on a class project. Thank you posting useful information and its now becoming easier to accomplish this task. best auto sales

awolf45
awolf4547 weeks 4 days ago

Changing Email Message

Hi, Thanks so much for this video.  I'm all set up and my spreadsheet is working, I just need to change the email message  I'm sure there's a way to do this, but I'm not sure how.  Any help would be greatly appreciated!

 

Amanda

andrew
andrew1 year 26 weeks ago

Just FYI this uses the "old" version of the PushData script

The newer version lets you "nickname" the spreadsheet you are pushing to, which makes it much easier to keep track when you are using it with multiple destinations.  It also uses the "Sheet Name" (instead of number) to designate which sheet in the destination spreadsheet to push to.

You can find the newer version of the PushData script in the master student list template at http://www.youpd.org/content/diy-student-information-system-module-1-lateness-zapper

jspevack
jspevack1 year 27 weeks ago

Pre-populated Forms as a Schedule Maker

I took this pre-populted form technique and adapted it for the iSchool scheduling process. The problem of practice is how can we eliminate scheduling errors and decrease the overall time necessary to create a school schedule. The answer this trimester is to have multiple administrators simultaneously schedule students using a Google Form. Giving more users access to the student enrollment process decreases the amount of time required to enroll the entire school. Prepopulated forms decreases the amount of possible errors in the scheduling process.

  • Using data from transcripts, I created a google spreadsheet with all of the classes that students are required to take. The columns are:
    • Student name
    • OSIS
    • Advisor
    • Grade
    • Required class in A Block
    • Required class in B Block
    • Required class in C Block
    • Required class in D Block
    • Required Online course
  • I created a separate Google Form with the following fields
    • Student name
    • Osis
    • Advisor
    • Grade
    • Block A
      • Drop down menu with all courses offered during this block
    • Block B
      • Drop down menu with all courses offered during this block
    • Block C
      • Drop down menu with all courses offered during this block
    • Block D
      • Drop down menu with all courses offered during this block
    • Module Class
      • Drop down menu with all courses offered during this block
    • Online Class
      • Drop down menu with all courses offered during this block
    • Commnets
      • This is an optional field for notes as the schedule team enrolls students in courses.
  • Using Andrew's technique in the helpful video above, I used the =Concatenate function to create URLs for every student. The prepopulated form pulls the data from the requirements spreadsheet. The results are student-specific forms that include:
    • Student name
    • Osis
    • Advisor
    • Grade
    • Required classes are already selected from the drop down lists
andrew
andrew1 year 26 weeks ago

Thanks for sharing

Great to hear you are having such success adapting this to your use case.  I would love to come by and have a look at it.

Cheers!

jspevack
jspevack1 year 30 weeks ago

Great Solution

This form collection tool has a lot of uses. So far I'm using it to set up meetings with my advisees. I will also use it to program students into their Trimester 2 schedules. The screencast explains every step. Thanks Andrew.

andrew
andrew1 year 30 weeks ago

Thanks for props...added tips

Sweet, glad to see someone using this!   The embedded scripts can also be taken and re-purposed for all kinds of things.  Pushing columns of data between Spreadsheets is powerful stuff.

I know you got stuck trying to add the "Send Emails" script to be triggered on form-submit.  For the sake of others, it seems you need to authorize a script before it shows up among the scripts available to be triggered.  Before you can be prompted to authorize, you need to manually run it from the "Script Manager."

Anything to add here Jesse? 

Really Simple Signup System
andrew's picture
Featured
Published: 09/27/11
License: Creative Commons Attribution-NonCommercial 3.0 Unported
Views: 3,026
Google Apps for EDU
Google Apps Script

Problem of practice

How can you efficiently allow for users to sign up for events with limited seats, time slots, resources, potluck items, etc. without opening up a spreadsheet for the world to edit?

Solution

This hack provides starter templates for a pair of Google Docs worksheets (one private, one public) that can then be connected using (included) Apps scripts to encourage users to submit Google forms only for open time slots or resources. Test.

Cast your vote

9
Recommend

Tweet this

Post to Twitter Post to Twitter

Browse other items with similar tags

Take hold of student projects in Google Docs with the Doctopus script
Written by an educator for educators, the free doctopus script gives teachers the ability to auto-generate, pre-share, and manage grading and feedback on templated Docs for group and individual projects.
Recommended by 96 educator(s).
autoCrat Document Merge Script: So You Don't Have to be the Bureaucrat!
The autoCrat Script was written to be a multi-purpose document merge tool that allows you to take any personalized, row-based spreadsheet data and create, save, attach to email, and share templated documents. No scripting ability required to use.
Recommended by 147 educator(s).
Close the Communications Loop with a Forms-Driven Email and Tracking System
The formMule (aka "The Mule") is a Google Apps script that is useful for automating lookups, emails and calendar events created dynamically from Google Forms.
Recommended by 29 educator(s).
Handout Generator
This is a simple script housed in a google sheet that allows teachers to create handouts for their classroom, shares the student appropriately and organizes the handouts in a collection. It can be used to create sheets as well as docs.
Recommended by 12 educator(s).
Embed a User-Specific Progress Chart in Your Google Course Site
This hack shows how to install a Google Apps Script in your Google Site to look up the grades of the currently logged-in student or parent and generate a live bar of progress from your Google spreadsheet!
Recommended by 12 educator(s).
docAppender: Using a Google Form to add content to the end of existing Google Documents
The docAppender script installs on the form-containing spreadsheet and provides users a web app where they can easily select which document they want to append. This is especially useful for logging meeting takeaways or keeping running records on faculty or student files. Very mobile friendly, as all usage involves URLs that can be loaded in a smartphone or tablet.
Recommended by 7 educator(s).
DIY Student Information System: Module 1, "The Lateness Zapper"
This introductory module provides what you need to start building the modular and lightweight data system of your dreams. The first installment is a "Lateness Zapper" that automates logging, communications, and reporting on student lateness.
Recommended by 16 educator(s).