Embedding a Google Drive Folder in a Post or Page

A great way to organise and store resources is to put them all into a Google Drive folder. Here we show you how to embed the contents of a Drive folder into a post or page of your website.

Embedding a Google Drive folder is nice and easy. Just follow the steps below:

1.) Open up Google Drive and find the folder you want to use. Make sure the folder is shared correctly otherwise people won’t be able to view the contents when it’s embedded!

2.) Grab the ID of the folder. You can get this from the URL when you’re within the folder or from the folder sharing popup.


3.) Paste the embed code below into your post or page, replacing FOLDER-ID with the ID of your Drive folder. You can adjust the ‘height’ attribute to suit your needs.

<iframe src="https://drive.google.com/embeddedfolderview?id=FOLDER-ID#list" width="100%" height="400" frameborder="0"></iframe>

Here’s a working example:

QR Code Generator in Google Spreadsheets

We stumbled over the option to create QR codes in Google Spreadsheets last week and thought it was a great way to create and list all of your QR codes. 

Here is a link to a Google Spreadsheet you can take a copy of to try it out for yourself.


From the spreadsheet you could print out your QR codes, share them, or screen grab them to use in other web applications as images.

Google Docs Research Tool

Google have launched a new research tool that runs within your Google Docs.

It's great for quick fact finding or for creating really quick footnote citations.

If the tool is not available for you it might be necessary to turn on fast track updates for your school domain.  Please contact support at realsmart for help with this.

The research tool can be activated by selecting “tools” and “research” from the menu bar or by right clicking on any word or phrase and selecting “research”

Find out more from Google here.

Google Collections

Google Collections are a great way to organise and manage the sharing of your Google Docs.

Google collections give you the option to assign sharing permissions to a folder of Google Docs rather than the docs themselves. This means documents just have to be dropped in the correct folder and Google does the rest!

Continue reading

Restrict users from submitting multiple entries to a Google Form

Google forms can be used to make vote or survey. However, it can not prevent multiple submission. Here is a Google Apps Script “voTer” to solve this problem. For each submission, the script will compare the “username” with previous recorded usernames. If the username is existed, then the new submission will be deleted. At the same time, an email will be sent to that person for notification. Please do tailor the highlighted part in the script to fit your situation.

Continue reading

Mail Merges in Google Docs with AutoCrat

The only thing you cant do with Google Apps that you can do with Office is mail merge, right?


Here is how….

  1. Create a spreadsheet and organize your data in columns that include one row per individual that you want to create a personalized document for.  Make sure each column has a header. Individualized data might also be fed by a Google form.
  2. Go to Tools->Script Editor and delete the existing code, pasting in the script from the attachment below.
  3. Save the script with a name.  I like to call it the “autoCrat”;)
  4. Use the small dropdown in the scripts editor to Run the “onOpen” function.   This will prompt you to authorize the script.
  5. In order for the script to work, you will need to create a Document to use as a template for the merge.
    1. Create a new collection for your templates.  I like to create a collection called “Merge Templates”
    2. Include double bracketed tags for any personalized data you want to populate from the spreadsheet.  Ex) <> .  It doesn't matter what you call the fields, because you will map them to your spreadsheet headers in a few steps.
  6. Refresh your spreadsheet in your browser.  Wait a few seconds and you should see a new menu item to the right of “Help”, called “Document Merge.”  If you don't see it, try running the onOpen function from the script editor again.
  7. In the “Document Merge” menu, select “Settings” and complete the settings.  If you don't have a collection that contains a template file with <> in it, go back to step 5 and come back to this.
  8. Now you will see a new “Document Merge” dropdown item, “Set Field Mappings.”  Map each <> to the spreadsheet column you want to use to populate it.  Save the mappings.
  9. Another new “Document Merge” dropdown item will appear: “Test/Run Merge”.  Select it and decide what type of merge you want to try…there are a number of combos and cool possibilities.  Look to the bottom of the panel for a clue as to the $variableNames that are available for any of the fields you want to populate dynamically per row.
  10. Here are some basic options to play with.  Checkbox allows you to test on first-row only if you like.
    1. ONLY saving merged Docs to a collection, either as PDF or Doc format.
    2. Saving to a collection AND emailing PDF as attachment.
    3. Saving to a collection AND emailing recipient a link to individually shared Docs as View-only
    4. Saving to a collection AND emailing recipient a link to individually shared Doc as Editor
  11. Note that as of Version 1.1.0, Date formatting can now be handled. You must use the Format->Number menu from the spreadsheet to format any dates.  Currently only three formats are supported:   “M/d/yyyy”, “MMMM d, yyyy”, and “M/d/yyyy H:mm:ss” … i.e. 1/30/2012…January 30, 2012, and 1/30/2012 9:32:34.
  12. Note: As of Vertion 1.2.0, the document Header and Footer can now contain merge tags.
  13. 1.2.1 fixes a silly bug that occurred when the document didn't contain a header or a footer.
  14. We also recently discovered that non-alpha merge tags don't work.  Eg <<90>> will not work.  Needs to be <>.  So avoid using anything in your merge tags that's not a letter.

Thanks to the folks at http://www.youpd.org/home for this great script.

Here is the text files with the script – autocrat_1.2.1