Showing posts with label Google Drive. Show all posts
Showing posts with label Google Drive. Show all posts

Put a survey questionnaire in your blog, using Google Drive's forms tool

This article shows how to use a Google Drive form to put a survey questionnaire into your blog or website.


How to make simple questionnaire forms in Blogger

Blogger's Poll gadget is a tool for putting a question onto your blog, which you visitors can answer. The gadget collects the answers for you, and shows the results.

This is very easy to do: you just add a gadget in the usual way, and set up the question and answer options, and the expiry date (ie the date after which you won't accept any more answers).

And with some template editing, you can arrange to put this gadget either above or below your blog-post gadget and only show it on certain posts or pages - so it's an easy way of running a very simple survey on your blog.

But it has a lot of limits: you can only ask one question, answers must be from a pre-defined list of possible answers, there is no other way for you to collate the results, etc.


Google Drive Forms are a better way to build a poll or survey

There are lots of tools that let you build a survey which you can embed into your website.   Some are paid services, while others (eg Survey-Monkey) are called "freemium services" - they give you a limited service for free (eg up to 100 responses) but have a charge for services above that.
.
Google Drive's Forms feature is another option.    Being from Google, you can be fairly sure that it will always be compatible with Blogger.   And it's set up so responses are put straight into a spreadsheet -  you don't have to manually receive and do data-entry for each one, thus saving you time.

Forms lets you build a data-collection page which you can put into your blog as a survey (or as a feedback form, etc).   It's better than using the Blogger Poll because it lets you:
  • Ask more than one question (I think there is no limit on the maximum number that can be asked)
  • Have different types of answers
  • Choose a theme (ie a standard graphic / layout format for the form)
  • Choose whether or not you are currently accepting survey responses (the "accepting answers" field is a toggle between accepting and not-accepting)
  • Choose whether the answers are stored inside the form itself, or in a separate Google Drive Spreadsheet file - the latter lets you do analysis of the results, without affecting the form.


The types of answers that you can choose from are:
  • Text - ie a short phrase, which includes numbers and other special characters.
  • Paragraph text - ie a longer field
  • Multiple choice (you set a list of valid values, a person can only choose one)
  • Checkbox (you set a list of valid values, a person can select as many as they want)
  • Choose from a list (you set a list of values which are shown as a drop-down list, a person must select one)
  • Scale  (eg "rate this between 1-5 where 1=outstanding, 5 = dreadful).
  • Grid  (a matrix of subquestions and possible answers - see the example form below)
  • Date  (a date value, with or without a time component)
  • Time  (a time value, measured in hours, minutes and seconds, am/pm)

You can break up the survey over multiple pages (by selecting Insert > Page Break in the form editor. And you can add section headers (text), pictures, videos the same way.


How to build a questionnaire for your survey using Google Forms


Log in to Google Drive, using the account that you want to own the form and the response data.  Note that this does not have to be your blogger account.


Choose Create > Form


Give the form a title and choose a theme from the list that is displayed.


Create your first question:
  • Enter the question and help text, 
  • Choose the question type and answer options, 
  • Set up any data validation rules, 
  • Click Done when finished.


If you want to add another question, click the Add Item button - and keep doing this until all the questions you want are on the form.
(Hint:  it's often easier to sketch out your questions on paper or a wordprocessor first - it's easier to think about how you should ask good questions when you're not worring about the mechanics of setting them them up in the system at the same time.)





Re-arrange the questions by clicking on the bar at the left and side, and drag them up or down to the right place.


When you have finished adding questions, click the Send Form button.


This opens a pop-up window where you can choose to send the form on Google+, Facebook or Twitter - and it gives a link to the form that you can put into emails etc.



To put the form, instead of just a link to it, onto your blog or website, click the Embed button.


Set the height and width, then click into the code field. Press Ctrl/A to select the whole field, and then Ctrl/C to copy the HTML code that is provided.


You can then install this code into your blog etc the same way you would install any other 3rd party code.


Job done!   

You now have a questionnaire form on your blog - and people who answer the it will do the data-entry for you.



What do your readers see

People who visit your blog using a web-browser will see a survey-questionnaire, which has all the questions you set up, and had radio buttons, checkboxes etc if you use them.

I'm still discovering what email and RSS subscribers see - it may depend on what type of email software and feed-reader they are using.   (I hope to update this sentence shortly after publishing this post.)

A sample questionnaire looks like the one below.  This doesn't contain real questions.   Rather I've just made one question of each type to show you what they look like:   feel free to enter some answers and  experiment with how the options work.   It has a very strong pretty theme / colour-scheme:   I chose this to make sure that it stuck out, but there are some more subtle / professional-looking themes available too.






Troubleshooting the form creator


Changing the form size

The code for an embedded survey form looks like this:
<iframe src="https://docs.google.com/forms/d/GEEKY-NUMBERS-REMOVED/viewform?embedded=true" width="500" height="500" frameborder="0" marginheight="0" marginwidth="0">Loading...</iframe>
You can change the values for width and height, margin width and height (all measured in pixels) without going into the Forms editor.   You can also set the frame border - not yet sure what the unit of measure and options for this are.

Cannot add another question

If you enter a question and select Done, but the Add Item button is greyed out, then your internet connection may be slow: check it, or try again at a later time.


What other trouble-shooting tips or questions do you have?





Related Articles:


Installing 3rd party HTML into Blogger

Adding a gadget to your blog

Showing a gadget only on a specific post or page

How to replace a file in Google Drive with a new version

This article is about how to update a file that you have loaded to Google drive. It only applies to files that have not been converted to Google Docs format - for example, PDF, Word, Excel etc files.


New versions vs new files in Google Docs

On a couple of my blogs, I provide files that people can download and use themselves.

When you share a file in this way, there are three main issues to consider:
  • Where to put the file
  • How people will find it
  • What format to use.


Today, Google Drive is the most obvious file hosting option for people using Blogger. (A file host is somewhere that you can put files which Blogger cannot upload - see File Hosting options for Blogger for more details and other alternatives.)

I thought a lot about the best format to use for these files: if I convert them to Google Drive (AKA Docs) format, they won't count against my file-storage quota, and everyone has access to Google Drive/Docs.  But not everyone has a Google account, or access to Docs at the time when they want to work on the file. And some people might struggle with using Word tables and formatting. So in the end, I decided to stick with MS Word and PDF formatted versions, for now at least.

And I tell people about these files by writing a blog post (eg "Table Quiz Answer Sheets") introducing the template, and put a link to each files in it (eg like the picture on the right for the PDF version - for info about how I did this see "Putting text and pictures side by side" ).

However I know that some people choose to note / bookmark / share / etc the location of the file, rather than the blog post. This is fine by me: the point of my blog is to provide tools, templates and advice. I ENsure that there is branding and a link to my blog on the downloaded files, so everyone who sees the printed version knows about my blog.   But I'm not fussed if some repeat-business goes directly to the files - I think they'll come back back to my site when they need advice or a different template.

But what happens if I want to change the file, for example to fix a typo that was missed originally, or to add a new feature?

If I just upload a new Word or PDF file to Google Docs then the links to this file will be different - even if it has the same name as a previously uploaded file.   People who go directly to the original file file will get the old (wrong) version - or even worse, I'll delete it and they will have a broken link.

However I've found that if I use Google Drive's tools for loading a new version of the file, then people with the link will always go directly to the latest version - and I can choose whether to keep the older versions inside Drive, or to delete them.


How to load a new version of a file to Google Drive


Log in to Google Drive, using the Google account that owns the document.


Navigate to the folder that the file is in.


Tick the document that you want to replace or update


Select More, from the navigation options bar above the list of documents


Go to Manage Revisions




Upload your updated version, using the Upload New Revision link:



If you want, delete the older non-current one using the "x" checkmark to the right hand side of the screen.




Job done:  anyone who goes to the existing file link will now get your most-recently-uploaded version of the document.



Troubleshooting

If there is no "Manage Revisions" option, then most probably the file is in native Google Docs format rather than another like Microsoft Word or PDF.   In this case, you need to edit it on-line.  Unfortunately I haven't found a way to temporarily leave the old, unedited, version available to any one who looks at the file before you have finished opening it.   This could be particularly annoying if you want to make a lot of changes -  in this case, it may be best to convert the file back to a downloadable format (Word, etc) and work on it locally before re-uploading and then copy-and-pasting te new contents back to your original file.



Can this be done with the Drive desktop software?

The short answer is: I don't know.

 I have multiple Google accounts, for different blogs, so I've decided that it's safest to always use the web-browser based tools to manage files in Drive, rather than try to work with different accounts on different areas of my local file store.

If you do know, please leave a comment below.




Other options?

I'm certain that there are othr tools in which it's easier to replace an existing verison of a file with a new one without changing the link to the file.    The following notes discuss the ones I've tried so far.


Google Sites

Originally I used "filing cabinet" pages in Google Sites to store the files which I make available. This has a couple of advantages:

If you upload a new file with the same name, then
  • The link does not change
  • The sharable link includes the original file-name, which makes it easier for me to be sure that I'm putting the right link into my blog posts.

However, Sites isn't Google's preferred way of managing documents now and I have a nasty feeling that one day it may go the same way as Google Pages, Reader, Picnik, etc.  So I decided a while ago to stop using Sites for this.



Related Articles:

File Hosting - places to store files that you use in your blog

Understandiing Google Accounts

Showing things side-by-side in Blogger

Google Buzz's last-gasp addition to your Google Drive

This QuickTip is about a file that Google Buzz is going to put into your Google Drive, as part of it's final turn-off routine, for all Buzz accounts that haven't yet been deleted.


quick-tips logo

Google Buzz was one of Google's early-and-short-lived social networking attempts, but was used by some bloggers looking to promote their blogs.

It was closed down in October 2011

I haven't seen it published in any of the Google blogs that I follow, but recently I was sent an email saying that the last step in the close-down will happen on or after 17 July 2013, when Google will save a copy of the Buzz posts from any remaining active Buzz accounts to the account-holders Google Drive

There will be two types of file, and the files won't count against your storage limits.   They say:
  1. The first will be private, only accessible to you, and have a snapshot of the Google Buzz public and private posts that you wrote.
  2. The second will have a copy of your Google Buzz public posts. It will be visible to anyone with the link, unless you change it later, and may appear in search results and on your Google Profile (if you've linked to your Buzz posts).   Any existing links to your Google Buzz content will redirect to this file.

Something to be aware of, if you used Buzz to make controversial comments:   Comments that you made on other users' posts will be saved to those users' files. After the file-download described here id done, the other user can change the sharing settings of those files, if they choose to do so. And if they do, and if you have commented on another person's private post, that person could choose to make that post and its comments public.   To remove the chance of that happening, you could delete all your Buzz content well before 17 July 2013

The Buzz-download Google Drive files will only contain comments from users who had enabled Google Buzz.  They won't include any comments that you deleted before Google moved your data to your Google Drive.

Add Google Drive's one-click-new icons to your blog or website

This Quick-Tip is about Google Docs / Drive's new short-cut buttons for making a new document, spreadsheet or presentation - and how you can install them into your blog.

Google have announced that one-click icons to create a Document, Spreadsheet or Presentation (now called Docs, Sheets, and Slides respectivly) are available as apps in the Chrome Web Store (a place where you can get various useful tools to install to your Chrome desktop or toolbar.

This is great for people who use Chrome - but some people don't,  for whatever reason.

Another option is to simply put links to the new commands into a place that you visit often - like your blog.  I've done this with a gadget called "Make a file in Google Drive" which you can see in my sidebar now.

To add this to your blog, simply add a HTML/Javascript gadget in the usual way, and put this code into the contents field.
<div style="text-align: center;">
<div style="display: inline-block; margin-right: 1em;">
<a target="_blank" href="https://docs.google.com/document/create"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgOnzFF_6SJxwEOU-Fl_f4JsE_JuJWAQcRENJmt9eXkP732KQFR28LPpw0SbkK2NstjNM6jL45rtPJrlzf9W_3hYQY704cIQCFrlexBBwiRkYFiXbRh97e5vu3iATyatQe7oz7Um1H4gMo/s80/made-new-word-processing-document-google-drive.png" /><br />
Document</a></div>
<div style="display: inline-block; margin-right: 1em;">
<a target="_blank" href="https://docs.google.com/spreadsheet"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTTsPVsrsOchgVt5bigVOr4mOJNV3yLe5KhAqcAwe1PURW4_n8h3TLVD5ui8LFGneQqkfiGb9heYVzxtUuShS1405BVAYQmmhKA6xzWcalEOaUHZtHbyCLS4AJDvVM8lws5ewIt_Q8ZeL9/s80/made-new-spreadsheet-google-drive.png" /><br />
Spreadsheet</a></div>
<div style="display: inline-block; margin-right: 0;">
<a target="_blank" href="https://docs.google.com/presentation/create"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8LLZ9VVaSV-inMFI5wFKvHr4FOYyLK4vEux1yc5g2LHcr5Je-z5HVj6E5OyD-YDlZQ1PXvbBgebBqYZnpvxLy5236u_HTIhO2YerObDvmaK8_-qh8BGgiG9LNOcL9V2sey2afphncxpDC/s80/made-new-slideshow-google-drive.png" /><br />
Presentation</a></div>
</div>
<!-- Google drive new file icons gadget, via www.areyoublogger.blogspot.com.   Share and enjoy!  -->

Features

  • There is no gadget title in the code, so that you can put whatever title you want into the title field of the gadget. 
  • People can click either the picture of the text to create a new document - and when they do, the new document will be opened in a new tab or window.  Your blog (etc) will stay open in its current tab or window.
  • There is one "em" of space between the icons - this is enough to look good on most blogs.   However if your sidebar (or wherever you put the gadget) is particularly wide you might like to increase it - do this by finding "1em" in the code above, and replacing it with a larger value.

Code for just one type of document

You don't have to put the code into a gadget - it can go equally well into  a post - for example if you want to tell people to make a document of their own, and do it "right now".

In this case,you might like to show just one type of document icon, rather than all three.   The blockks of code for that are shown below - note that I would usually recommend pasting them into the HTML view of the post editor, to be 100% certain that they work correctly.

To make a new word-processing document:

<div style="text-align: center;"><div style="display: inline-block; margin-right: 1em;"><a target="_blank" href="https://docs.google.com/document/create"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgOnzFF_6SJxwEOU-Fl_f4JsE_JuJWAQcRENJmt9eXkP732KQFR28LPpw0SbkK2NstjNM6jL45rtPJrlzf9W_3hYQY704cIQCFrlexBBwiRkYFiXbRh97e5vu3iATyatQe7oz7Um1H4gMo/s80/made-new-word-processing-document-google-drive.png" /><br />Document</a></div></div><!-- Google drive new file icons gadget, via www.areyoublogger.blogspot.com.   Share and enjoy!  -->

To make a new spreadsheet file:

<div style="text-align: center;"><div style="display: inline-block; margin-right: 1em;"><a target="_blank" href="https://docs.google.com/spreadsheet"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTTsPVsrsOchgVt5bigVOr4mOJNV3yLe5KhAqcAwe1PURW4_n8h3TLVD5ui8LFGneQqkfiGb9heYVzxtUuShS1405BVAYQmmhKA6xzWcalEOaUHZtHbyCLS4AJDvVM8lws5ewIt_Q8ZeL9/s80/made-new-spreadsheet-google-drive.png" /><br />Spreadsheet</a></div></div><!-- Google drive new file icons gadget, via www.areyoublogger.blogspot.com.   Share and enjoy!  -->

To make a new Google Docs / Drive presentation:

<div style="text-align: center;">
<div style="display: inline-block; margin-right: 0;"><a target="_blank" href="https://docs.google.com/presentation/create"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8LLZ9VVaSV-inMFI5wFKvHr4FOYyLK4vEux1yc5g2LHcr5Je-z5HVj6E5OyD-YDlZQ1PXvbBgebBqYZnpvxLy5236u_HTIhO2YerObDvmaK8_-qh8BGgiG9LNOcL9V2sey2afphncxpDC/s80/made-new-slideshow-google-drive.png" /><br />Presentation</a></div></div><!-- Google drive new file icons gadget, via www.areyoublogger.blogspot.com.   Share and enjoy!  -->