Google-forms – Limiting the amount of Google doc’s forms that can be submitted

google-forms

I'm arranging an event and I'm using Google Forms so people can sign up. I can only have 100 people and want the sheet to stop accepting new signups to the form when the number is 100. Is this something that we can do with Google Docs Forms?

If you can do this, can you also make it so that the form changes to a message saying that it's now full and you can sign up on a waiting list where you might be able to go?

Best Answer

Theres a workaround using a spreadsheet to access the form.

A few useful examples are available in this thread;

http://www.google.com/support/forum/p/Google%20Docs/thread?tid=039da52385b9d224&hl=en

Hope this helps.

Related Solutions

Google-forms – Google docs forms confirmation email when someone signs up

It's possible but you'll need to do a little scripting

Sending an email after a form submission is such a common task that Google has a complete tutorial to show you how to do it.

Take a look at:

Tutorial: Automating a Help Desk Workflow

Just keep in mind that Google does put limits on the number of emails that can be sent. The limit depends on what type of account you have (ex. Education, Business, etc).

You can check your email use relative to the limit by calling:

MailApp.getRemainingDailyQuota();

Google Apps Scripting makes it easy to do complex tasks with some simple scripting. Just keep in mind that there are limits put in place to prevent abuse/spamming.

Google-forms – Make Google Forms in plain text

There is an add-on called: doc to form You can easily create a form using Google Docs and after that the add-on will generate the form. https://chrome.google.com/webstore/detail/doc-to-form/paadgjaehgkbopbjfaomaophiphlmalh?authuser=0

There is a demo on YouTube: https://www.youtube.com/watch?v=bc2mdj4kVJg

Best Answer

Related Solutions

Google-forms – Google docs forms confirmation email when someone signs up

Google-forms – Make Google Forms in plain text

Related Topic