Dan Raine’s Pink Thong and Google Spreadsheets

I just found out about an awesome feature in Google Spreadsheets that allow you to create fillable forms!

Check it out: Vote to see more of Dan Raine in his Pink Thong

This is very easy to setup and the data is automatically added to the spreadsheet!!! How awesome is that.

To setup…

____________________________________________

The first thing you need to do is create a Google Spreadsheet.

Go to Google Docs, clickNew, then Spreadsheet.

____________________________________________

Once you have a blank spreadsheet up, click Share on the right hand side.

____________________________________________

Under the Share this document section there’s a new option labeled as “to fill out a form”.

____________________________________________

Now your ready to edit the form. Click Start editing your form…

____________________________________________

click for larger image.

Now you’re ready to modify your form. Just like any other form you have the option to add text fields, paragraph fields, multiple choice, checkboxes, or choose from a list.

____________________________________________

click for larger image.

This is my example that I created within a couple minutes.

____________________________________________

click for larger image.

Now you’re done! The form is automatically linked to the spreadsheet that you created earlier. You can start inviting people to fill out the form or post the link directly to the form itself. Here’s the link to my example.

___________________________________________

Once people start filling out the form, the information is automatically populated in the spreadsheet. You can then begin to work with this data.

____________________________________________

Pretty cool isn’t it?

~Shannon