Friday, July 9, 2010

Bragto U: Using Forms Pt. 2

Bragto University
Class: DOCS 301 Using Forms


Recap:
Forms are a very powerful part of Google Spreadsheets and can help "automate" data entry and collection.  In the previous class, I outlined how to setup your Form to collect data.


Objective:
To publish the previously created Form to the web to enable use by those on the Internet.


Procedure:

  1. Couple of Notes:

    1. To get back to your form, open up the spreadsheet of the form that you created and click *Form --> *Edit Form.

    2. To allow information to flow "Accepting Responses" must be checked.  If you are done with the Form you can always turn it off by unchecking the option.



  2. Getting Started:  We need to get the information to either get a link or embed it in a webpage.

    1. To get a link to your form:

      1. In Google Spreadsheets, click on *Form --> *Go to Live Form.  This will bring up a new browser window with your form.  Copy the URL from that webpage and link it on your website.



    2. To embed it in your webpage:  This would show your form on your webpage, no need for an external link.

      1. To get back to your form, open up the spreadsheet of the form that you created and click *Form --> *Edit Form.

      2. In that new window click on *More Actions --> * Embed.

      3. Copy that code.

      4. Now in the HTML of your webpage, simply paste that code in.  Now when you load that page your form will be embedded in your site.  (An example of an embedded form.)

        1. You need access to the site's HTML code.  Most modern webpage creation is done WYSIWIG.  If you paste it into a WYSIWIG editor, you will just see the code.  If you don't know how to access your HTML code, maybe using a link would be easier!








3 comments: