12 August 2009

Simplify your life with Google Forms.

Suppose you want to collect the data regarding the Birthdays of your friends and relatives. One option is to collect the data and enter it into spreadsheet.

Wait! Google has simplified this matter. Click on New/Form in Google Docs and create fields for last name, first name and date of birth, save the form and click on "email this form" and chose contacts from your gmail account and send. Your friends will fill the data themselves and it gets collected in the spreadsheet on your Google Docs account as soon as they fill it.

If you don't want to create a form yourself you can use my template:


If you are not logged into your Google Account you may have to create one or login to an existing account.

The form will open in front of you and it will be automatically saved in your Google Docs. You can click on 'Save' button on top right corner if its status is not showing as 'saved'.

You can edit the form if you wish like adding more fields or you can click on 'Theme Pink Flowers' and select another theme e.g. "Birthday Baloons". For changing theme you have to click on 'Apply' button.

After editing the form and/or changing theme if necessary you can click on "Email this form'. If you have a gmail account and a contact list in it you can click on 'choose from contacts' otherwise, you can enter the email addresses of your friends and relatives in the 'to' box and click on send.

You can click on 'More actions/Edit confirmations' and see what the responders are going to see after they fill up the form and click on 'Submit' button.

The responses get collected automatically in a spreadsheet 'Copy of Birthday' in your Google Docs and you can view them any time by opening it.

You can edit the form from the spreadsheet by Form/Edit_Form. You can input the Data yourself by clicking on Form/Go_To_Live_Form.

No comments:

Post a Comment