Share ideas that matter on the social web and experience
the benefits of curating the world's best content.
I don't have a Facebook, a Twitter or a LinkedIn account
|
Scooped by Martin Hawksey onto Google Apps Script |
Scoop.it!
Tim Saunders has started a new blog of Google Apps Script Snippets. Current posts include:
* Create your first Google Apps Script
* Understanding the Form Submission Trigger
* Creating a usable object from a form submission
* Creating a formatted HTML table in an email body
Are you sure you want to delete this scoop?
 Your new post is loading...
Scoop.it!
"During a recent Google Apps migration project, we received several requests to create custom groups of contacts so that users could more easily email frequent collaborators. Before switching to Google Apps, users created their own private distribution lists — but this approach led to overlapping groups that quickly fell out of sync.
The problem was a perfect case for Google Apps Script. We built a great solution that gives users as much power as possible with just a quick administrator review." Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
"We've shown you the wonders of Markdown as great for your to-do lists and notes. If you love Markdown too but you're stuck with a bunch of Google docs that aren't in the format (but need to be), this Google Apps Script converts them instantly."
Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
"The BetterLog library extends the native Logger with one line of code and gives you additional features like logging to a spreadsheet and more."
Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
" Gmail uses schema.org markup to accelerate user actions and to highlight the most important information users need from an email. Gmail supports 4 types of actions and 1 interactive card: RSVP Action for eventsReview Action for restaurants, movies, products and servicesOne-click Action for just about anything that can be performed with a single clickGo-to Action for more complex interactionsFlight interactive cards"
Martin Hawksey's insight:
This tutorial shows how you can use Schema in Gmail with Apps Script Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
" My goal was simple – get a search results page from seek.com.au, load it as DOM, run a CSS select to find the element that I need and write the value of that element into a spreadsheet that I use for tracking/analysis."
Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
"Recordings of Google Apps Script office hours, I/O presentations, and other videos for developers." Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
"The goal is to make a test component that pulls questions from a bank based on tags and assigned student. You can make questions from a UI or in the spreadsheet. I think with the hints, answers, reference, explanation widgets I'm (will) building, it will still be better than what can be built in the new FormApp tools. Please offer feedback or let me know if someone has already built a tool like this." Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
The Google Apps Script team have recently announced a host of new features. The three that caught my eye were: Script editor added to Google Docs and Forms Addition of the Forms Service which lets ...
Martin Hawksey's insight:
Thought I'd try out sidebar in Google Docs by replicating the MS Word Navigation Pane/Document Map. Didn't get jump navigation to work but reckon with a bit of jQuery I could get it to change document structure. Useful to find the current limitations. 
brucemcpherson's curator insight,
May 19, 4:42 AM
it's only onlybeen available for 2 days, and already Martin Hawksey has fiddled with it... ;) Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
This Wednesday is the start of our annual developer conference, Google I/O, and we can’t wait to share a bunch of new features that will help developers do more with Apps Script. So let’s not wait!
Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
In the IDE, Option - Up/down arrow (Alt - up/down arrow on Windows) moves a line up or down the screen. Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
Ready for a ramble? In this post I take you on a journey from my dotbirth, RSS feeds, Chrome Apps, touching upon how I created an RSS feed for Scoopit searches, before kicking the 'Tin Can' Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
This video describes the process to use the FormMule script to mark a Google Apps Ninja quiz and have the quiz results mailed directly to the student and/or ... Via Tom D'Amico (@TDOttawa) Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
Recently, Justin Marckel, the assistant principal at Cornatzer Elementary School in North Carolina, asked for help in modifying one of my existing Apps Script examples.
Delete the scoop?
Are you sure you want to delete this scoop?
Yes
|
Scoop.it!
" I frequently use Google Spreadsheets as a lightweight database, by setting up some columns, encouraging my colleagues to update it, and subscribing to notifications of changes. Then I export the spreadsheet as JSON and update a json file in our codebase. Sometimes I also just use the jsonp output of a published spreadsheet, but if I'm worried about performance or the information getting mis-updated, then I'll use the export-and-update approach. In order to export it as JSON, I used to use a Google Spreadsheets Gadget but now that those are deprecated, I use a Google Apps Script."
Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
Here's the complete implementation of site explorer using d3.js, and tag data generated by Google Apps Script from a Google Site Via brucemcpherson
brucemcpherson's curator insight,
June 3, 2:23 PM
This can be generated directly from Excel, or not. Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
"A while back Jo Gilham wrote a blog post about using Google App Scripts to automate certain process related to the university VLE. App scripts are little bits of code that are inserted into an app such as Google Docs, Spreadsheets or Forms that will trigger certain events: for example, it will send a templated email/document when certain conditions are fulfilled such as someone completing a form. I remember reading it and thinking I would love to try this but I’ve always been put off by anything that looks remotely like programming code." Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
"One the things I wanted to play around with was visualizing this site content with d3. But first I needed to create something which would generate data from the site (any domain site actually). It's easy enough to modify for non-domain sites but I'm starting with domains, since that's what I have."
Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
With massively refreshed Google Docs/Drive APIs, use JavaScript to integrate to your heart's content, create new apps Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
In this post I want to cover three things. First I want to introduce a little app I’ve developed which allows you to create a RSS feed for any of your Gmail labels (with the option to remove certain links – useful if you don’t want others unsubscribing you from mailing lists). Secondly I explain how it was made and how you can use it yourself. Finally I want to discuss how this could be used in an open course environment, utilising the vast processing power from services like Twitter and reusing there target marketing emails to your benefit with a bit of ‘dark social judo’. Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
"The other day I was looking around for an example of how to do digest authentication in Google Apps Script (or even plain javascript). I found plenty of theoretical discussions on it, but no actual examples. So here's an implementation walkthrough. ... What is Digest AuthenticationWorking with GAS, you'll probably be more familiar with oAuth2, which is supported well through the UrlFetchApp class. However some APIS still use Basic authentication, or the slightly more secure Digest Authentication"Via brucemcpherson
brucemcpherson's curator insight,
May 21, 7:03 PM
The other day I was looking around for an example of how to do digest authentication in Google Apps Script (or even plain javascript). I found plenty of theoretical discussions on it, but no actual examples. So here's an implementation walkthrough and code. Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
Google Apps Script. Html service is now 20 times faster!! Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
Pre #io13 Apps Script community member Sergii Kauk has been digging around the Script Editor for new features. Here's what he's discovered so far: "Seems like #io13 will bring us a few cool features. There're DriveApp (with MimeType companion) and FormApp top-level objects already as well as something called BigNumber. In File menu you'll find "Upgrade authorization experience" command which turns authorization flows to OAuth 2. Finally, in doPost event object there's a new key called "postData" which I personally find one of the most interesting because it finally solves that nasty issue #2158 and makes GAS pretty handy for Glass development."
Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
Google apps script version of a VBA version of an original mashup of scraperwiki electoral data, mysociety api and openrefine. Via brucemcpherson
brucemcpherson's curator insight,
May 7, 1:26 PM
A Google Apps Script version of a VBA implementation of a post by Tony Hirst on his oUseful blog where he nicely laid out how mashup Open refine plus various APIs to research which candidates were standing for election in the wards in which they live. Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
"If you're wondering what's next for Google Forms, the source code reveals that Google will add support for rich-text editing, embedding images and that Google Forms will integrate with Fusion Tables and Google Scripts (codename "maestro")."
Martin Hawksey's insight:
HT +Kyle Beatty Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
I/O Sessions were just published... Looks like there might be updates to apps script to allow more use with forms, drive, and docs.
Delete the scoop?
Are you sure you want to delete this scoop?
Yes
|
