Matt Jones, ICT Manager at St Edmund’s Catholic Academy demonstrates how to perform a mail merge in Google Apps using the AutoCrat add-on.
Thanks Matt, a great tutorial!
Google Analytics allows you to track and view key stats relating to your realsmartcloud site. Not only is this hugely beneficial as you can track how, where and why people are accessing your site, it’s also easy to set up.
- Sign in to your realsmartcloud site.
- Open Google Drive.
- Open a new tab / window and go to http://www.google.com/analytics/
- Click ‘sign up’ and complete the information form.
- Once you’ve done this you’ll be presented with a ‘tracking code’. Copy this.
- Navigate to your realsmartcloud site, click the ‘WordPress’ icon in the toolbar and select ‘Dashboard’. You will need to be a wordpress admin.
- Select ‘smartOptions’ from the menu.
- Open ‘analytics’ and paste the ‘tracking code’ in here. Then click ‘save changes’.
Google Analytics is now set up on your realsmartcloud site. Simply go to http://www.google.com/analytics/ sign in and click ‘reporting’ and then select the relevant criteria.
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:
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.
The only thing you cant do with Google Apps that you can do with Office is mail merge, right?
Here is how….
- 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.
- Go to Tools->Script Editor and delete the existing code, pasting in the script from the attachment below.
- Save the script with a name. I like to call it the “autoCrat”;)
- Use the small dropdown in the scripts editor to Run the “onOpen” function. This will prompt you to authorize the script.
- In order for the script to work, you will need to create a Document to use as a template for the merge.
- Create a new collection for your templates. I like to create a collection called “Merge Templates”
- 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.
- 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.
- 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.
- 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.
- 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.
- Here are some basic options to play with. Checkbox allows you to test on first-row only if you like.
- ONLY saving merged Docs to a collection, either as PDF or Doc format.
- Saving to a collection AND emailing PDF as attachment.
- Saving to a collection AND emailing recipient a link to individually shared Docs as View-only
- Saving to a collection AND emailing recipient a link to individually shared Doc as Editor
- 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.
- Note: As of Vertion 1.2.0, the document Header and Footer can now contain merge tags.
- 1.2.1 fixes a silly bug that occurred when the document didn't contain a header or a footer.
- 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