I love the new feature of creating forms from a Google Docs spreadsheet and having the form information populate the spreadsheet automatically with a time stamp. The one thing I found limiting was there wasn’t an embed tag for the form so I could post it up on a webpage. I discovered this work around so that you can embed your Google form up on a web site so anybody can access and answer it (instead of just emailing it to other Google account users).

1. Create your spreadsheet by putting the fields of your form in row 1.

Google Forms

2. Click on the Share tab. Share tab google docs

3. Under Invite People, choose to fill out a form radio button. Radio button fill out form

4. Click on Start Editing your Form button. Start editing your form button

5. In a separate window, you can edit the fields text, the type of field (text box, paragraph field for comments, check boxes, multiple choice (radio button), and lists) . Click on Edit, or click on the arrows above or below edit to move the order of your form fields.

Edit Google form 1 Edit Google form 2

6. Click the Done button to finish your form field edits. Done button

7. Click the Save button at the bottom to save all your form changes. Save button

8. Now at the top of the window, click on the Preview and Send tab. Preview and Send tab in Google forms

9. Copy the link next to the sentence “If you can not view this form properly…” aka the view form key link.view form key link

10. Paste this into your webpage using iframe tags, like this:

<iframe src=”http://spreadsheets.google.com/viewform?key=key numer” width=”635″ height=”880″ frameborder=”0″ scrolling=”no” style=”margin-left:-15px;”></iframe>

11. Now your form is embedded on your web page. When anybody visits your form and fills it out, your spreadsheet will be filled in with their responses and automatically updated.

-Enjoy!

Advertisements