Using Online Forms

Online forms can be used to collect data and restrict the user to the desired type of response (i.e. short answer, paragraph, date, duration, checkbox, etc.)


Google Forms

Google Forms is a tool that allows collecting information from users via a personalized survey or quiz. The information is then collected and automatically connected to a spreadsheet. The spreadsheet is populated with the survey and quiz responses.

The Forms service has also received updates over the years. New features include, but are not limited to, menu search, shuffle of questions for randomized order, limiting responses to once per person, shorter URLs, custom themes, automatically generating answer suggestions when creating forms, and an “Upload file” option for users answering to share content through.

In October 2014, Google introduced add-ons for Google Forms, that enable third-party developers to make new tools for more features in surveys.

In July 2017, Google updated Forms to add several new features. “Intelligent response validation” is capable of detecting text input in form fields to identify what is written and ask the user to correct the information if wrongly input. Depending on file-sharing settings in Google Drive, users can request file uploads from individuals outside their respective company, with the storage cap initially set at 1 GB, which can be changed to 1 TB. A new checkbox grid enables multi-option answers in a table. In Settings, users can make changes that affect all new forms, such as always collecting email addresses.

  • Wikipedia

Below we have embedded an instructional video by Alex Anson

It does an excellent job of describing how GOOGLE FORMS was developed to allow designers and educators to create online surveys and / or quizzes. Presumably the creation of online surveys was the original impetus behind forms.

However as we’ll see later on, FORMS can also be a powerful tool in systems design to enable the collection of important records that enable staff – or clients – to collaborate remotely.

Forms can be accessed whenever the user is online simply by placing a bookmark in the user’s browser. In the example below we’ve embedded a GOOGLE form within this WordPress “blog”.


Smartsheet™ appears to have originally been designed for project management. It remains an excellent and very powerful tool for custom project management applications.

In the tutorial embedded below it is easy to see the project management focus.

However in this course we will use both GOOGLE FORMS™ and Smartsheet for a variety of record-keeping applications:

  1. timesheets
  2. payroll
  3. deposit books
  4. expense claims
  5. SR&ED documentation