posted 9 Jul 2010 10:11 by Stephen Hind
updated 26 Jun 2013 05:29 by Stephen Hind
Go to Google Docs (either http://docs.google.com for a personal account or http://docs.google.com/a/example.com for Google Apps uses, where example.com is your domain)
Use the Create New drop-down menu then choose Form to make a new form
In the form you need to make three required questions
- E-mail Address (so you can get back in touch)
- Message (or whatever you want to call it)
For further information on how to create forms see Forms: Creating Forms - Google Docs Help Centre
Save your form and return to Google Docs
Once back at Google Docs refresh the document list and open the new spreadsheet created for the form
Once in the spreadsheet use the Tools menu, then Script Gallery
Find the Contact Us Form Mailer in the Public section of the Script Gallery and use the Install button
When the Authorization Required dialogue box appears use the Authorize button
The script will now show as installed on the list of public scripts, so use the Close button to return to your spreadsheet
Use the Tools menu, then Script Editor...
- Enter your e-mail address in between the quotation marks on the
var recipient = '';
line, so it should now look something like
var recipient = 'email@example.com';
and use the Save button (it's a little icon of a floppy disc)
While still in the Script Editor use the Resources menu, then Current project's triggers...
In the Current Project's Triggers box use the No triggers set up. Click here to add one now link
From the drop-down boxes make sure that contactUsMailer, From spreadsheet and On form submit are selected and use the Save button.
Close the Script Editor and return to your spreadsheet. While you're there save the spreadsheet and close it.
Go to your Google Site and use the Edit Page button, then the Insert menu and then Spreadsheet form
Choose the form you have created and use the Select button, then choose the display options you want for the form (width, height title, border, etc) and then use the Save button
Use the Save button (top-right corner) to save the page and then you can test your form.
I have included the form below, so please do use the form to let me know what you think of the script.
click for larger images
Inserting a script
Script Installation Confirmation
Resources - Current Project's Triggers Menu
Current Project's Triggers