Google Apps Script
Follow
Find
46.7K views | +22 today
Google Apps Script
The GAS: All things related to Google Apps Script including examples, news and snippets
Curated by Martin Hawksey
Your new post is loading...
Scooped by Martin Hawksey
Scoop.it!

Apps Script quick tips: building a stock price spreadsheet by Ikai Lan

Apps Script quick tips: building a stock price spreadsheet by Ikai Lan | Google Apps Script | Scoop.it
"I’ve been using iGoogle less and less over the past few years. A few weeks ago, the team announced that iGoogle would be shutting down in November 2013. It’s not a huge loss to me, though I do check iGoogle several times a day. Why? Stock prices! I’ve been using the Stock Market gadget for years.

As it turns out, the functionality I want is very easy to replicate using Google Spreadsheets and Google Apps Script. I’m thoroughly convinced that the fastest way to wire up different Google services for custom functionality is this product. Google Apps Script provides services to access Google Finance APIs."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Creating Custom Learning Assessment and Student Feedback Applications with Google Apps Script

Here's a chapter from Cultivating Change in the Academy: 50+ Stories from the Digital Frontlines at the University of Minnesota in 2012 written by Abram Anders. The chapter covers the development of a custom assessment and feedback tool written by Abram and available in the Script Gallery

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Doodle for your domain using Google Apps Script - Apps Script Tutorial by Waqar Ahmad

Doodle for your domain using Google Apps Script - Apps Script Tutorial by Waqar Ahmad | Google Apps Script | Scoop.it
"I was looking on this post on Google Apps Developer blog, I thought, why not to develop the same functionality using Google Apps Script which will be easy to maintain and run.
So I made a Spreadsheet Application which will does the same for you.
In this application, you just need to write the URL of the doodle and Date for that Doodle logo."

Find a vast collection of Google Apps Script (GAS) demos and examples. GAS Tutorial, Google Apps Script Tutorial by Waqar Ahmad...
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Get the revision history of a resource using DocsList API - Apps Script Tutorial by Waqar Ahmad

To get the revision history of your resource in your Google Docs using Google Apps Script, you can use Google DocsList API with Google oAuth and URLFetch App.

Find a vast collection of Google Apps Script (GAS) demos and examples.GAS Tutorial, Google Apps Script Tutorial by Waqar Ahmad...
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Quarter of Google Apps Script tweets come from Japanese profiles inc @soundTricker318 @kwixilvr @ttyokoyama

Using the search "apps script" OR "Google Apps Script" OR "google script" OR developers.google.com/apps-script/ 'The GAS' has been collecting apps script related tweets since November 2011. Doing a quick analysis filtering profiles tagged with ja language code you can get  a sense of the size of the Google Apps Script community in Japan. So you might want to fire up Google Translate and start following @soundTricker318 @kwixilvr and @ttyokoyama

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Use Regular Expressions to Find Anything in your Gmail Mailbox with Apps Script - Amit Agarwal

Use Regular Expressions to Find Anything in your Gmail Mailbox with Apps Script - Amit Agarwal | Google Apps Script | Scoop.it

"Gmail offers some very useful search commands to help you quickly find messages that could be buried deep in your mailbox. For instance, a query like from:(John OR David) has:attachment after:2012/01/15 will locate all emails received in the past six month that have attachments and the send is either John or David.

 

The built-in Gmail search is powerful but there are some scenarios where it will not work. For instance, you cannot perform a wildcard search inside Gmail (like apples * red). Or how do you locate all emails that have a phone number mentioned in the message body? It is also not possible to perform case-sensitive searches inside Gmail.

 

You can however do all this in Gmail with the help of regular expressions (or regex)."

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Script has new project launch splashscreen in Script Editor

Google Apps Script has new project launch splashscreen in Script Editor | Google Apps Script | Scoop.it

Screenshot of the new project launch splashscreen in Script Editor. Clicking on 'Create script for'  includes sample snippets which can be used in your project

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

TXT Messaging + Google Apps Script to a Fusion Table - James Ferreira

"This video demonstrates how Google Apps Script can be used to process text messages and store data in a Google Fusion table.

 

This App is currently under development to help medical professionals record demographic information in remote parts of Africa where Internet access is very poor. In many cases the villages don't even have electricity but they do have cellular phone coverage allowing the use of text messaging."

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Experts: Workflow With Google Apps Forms (Apps Script)

"Google Apps has an easy built-in web Form tool that stores submitted results in a spreadsheet. This is good, but let's make it better.

 

Introducing Forms with Workflow!

 

Thanks to Google Apps Scripts, a workflow can begin once the form's submit button is clicked. The most efficient way to demonstrate this is through a video. Play the video to see how it works."

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

RavenDB HTTP API via Google Apps Script (JavaScript), Spreadsheets and Documents

Code snippet to get first 1024 items from a RavenDB index

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Playing around with the new Google Apps ScriptDB

"I'm taking a break from d3.js and playing around with the new Apps Script DB. Those of you who read these posts or follow the rambling site may know that I have been building up a library of classes, modules and procedures that have equivalents in both Google Apps Script and Excel.

 

So what shall we do with ScriptDB? Well it gives us noSQL persistent storage associated with a Google Apps Script project."

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Publishing to the Chrome Web Store - Google Apps Script — Google Developers

Publishing to the Chrome Web Store - Google Apps Script — Google Developers | Google Apps Script | Scoop.it

"After you've created a web app with Google Apps Script, you can distribute it to users by publishing in the Chrome Web Store. Google Apps Script has built-in integration with the Chrome Web Store to simplify the publishing process."

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Collaborative Tools Project: Building A Booking System With Google Apps

Collaborative Tools Project: Building A Booking System With Google Apps | Google Apps Script | Scoop.it
"In my previous post, Building a Booking System With Google Apps, I tried to use Google's UI Builder to be a front-end to saving events into a Bookings Calendar for students to book hot desks in the Berrick Saul Treehouse. I wasn't totally happy with the results... still.

Lately, I have tried a completely different, simpler approach ( with quite a few groans about icky Google Docs issues along the way ) which has a sort of spreadsheet visualisation of the bookings that have been made. "
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Page Rank REST API from Excel and Google Apps Script by Bruce Mcpherson

Page Rank REST API from Excel and Google Apps Script by Bruce Mcpherson | Google Apps Script | Scoop.it

"I haven't posted anything on new entries to the rest-excel-gas library for a while. As I mentioned in this post the library itself is available as a rest query. There have been quite a number of new APIs added lately through forum requests, but here is a nice one - populate a worksheet with the Google Page Ranks of a list of given domains. (you just enter the domains you want, the library call fills in the rest)"

more...
No comment yet.
Suggested by Jacob Jan Tuinstra
Scoop.it!

How to Forward Multiple Emails at Once in Gmail using Google Docs

How to Forward Multiple Emails at Once in Gmail using Google Docs | Google Apps Script | Scoop.it
Learn how to use Google Docs to forward multiple emails in Gmail at once to any number of recipients without the need of desktop clients.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Share docs between domain users - Apps Script Tutorial by Waqar Ahmad

"Google Apps Administrator have access control privilege for the documents of users in his/her domain. An administrator can share the document of one user to any other user in that domain. This is mostly required when you need to audit the documents of a domain user. Say, Bob's boss want to audit the documents of Bob and does not want to ask Bob to share the documents. In this case, Googe Apps Administrator can help Bob's boss."

Find a vast collection of Google Apps Script (GAS) demos and examples. GAS Tutorial, Google Apps Script Tutorial by Waqar Ahmad...
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google I/O 2012 Notes: New features in Google Apps Script (NoSQL, HTML/Content publishing and Chrome app publishing) JISC CETIS MASHe

Google I/O 2012 Notes: New features in Google Apps Script (NoSQL, HTML/Content publishing and Chrome app publishing) JISC CETIS MASHe | Google Apps Script | Scoop.it

One of the main questions I get from people interested in using Apps Script is how stable/sustainable the platform is. Given there were three separate sessions on Apps Script at #io12 announcing a number of new features including the launch of script.google.com I’d say for now things are looking very healthy.

 

There were (by my count) four new features of Apps Script announced outlined below, I’m throwing in one more old announcement, which I’ll share my notes on in this post:

 

* Recent announcement Managed Libraries and Versioning – this lets you control a master script which you can maintain and bug fixes, new features can be used by anyone using the library (before if you created a script in a spreadsheet and someone made a copy the script became orphaned so the only way you could receive updates was making a fresh copy or manually replacing the existing code).
* ContentService – lets you publish content generated by App Script which will be interpreted by other web services/tools as atom, rss, json, text or xml
* HTMLService – lets you publish content generated by Apps Script which will be interpreted by other web services/tools as html which can include custom CSS and client-side JavaScript (including importing existing libraries/code like jQuery)
* ScriptDb – a NoSQL style database that lets you store and query data that doesn’t have a fixed schema (doesn’t have a fixed number of values or may have nested data)
* Publish to Chrome Web Store – you can publish Apps Script based applications directly to the Chrome Web Store so that other people may easily install and use.

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Twitter Bootstrap in Google Apps Script (with source code) via @soundTricker318 #gasja

Twitter Bootstrap in Google Apps Script (with source code) via @soundTricker318 #gasja | Google Apps Script | Scoop.it

Twitter Bootstrap in Google Apps Script (working example with source code)

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Using Google Apps ScriptDB and the ContentService as an REST server - Bruce Mcpherson

"That's right - you can serve up data from your Google Apps Script directly. In my post the other day, I showed how to use the Google Apps ScriptDB as a place to store the  Rest-Excel library. Now ideally, you'd want to get that out again by making a simple API call - but we dont have a server. With the new Google Apps Script ContentService, you dont need one."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Create your own “Burndown chart” using Trello API and Google Apps Script

Create your own “Burndown chart” using Trello API and Google Apps Script | Google Apps Script | Scoop.it

"If you or your team are into Scrum and if you’re using Trello for managing your tickets, but still didn’t get the best of Trello – then you’re on a right place. If you don’t have a clue what Scrum is, but you’re interested in that – maybe you should do a little bit of research if you want to get the best of this post-tutorial."

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

More Power to Google Apps Domain Administrators with Apps Script (GroupsManager and NicknameManager)

"At the end of last year we launched the UserManager Apps Script service, allowing Google Apps domain administrators to write scripts to programmatically create, delete and edit their user accounts.

We are now extending the family of Domain services with two new additions: NicknameManager and GroupsManager."

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Gmail Meter is now available in the Chrome Web Store! - Romain Vialard

Gmail Meter is now available in the Chrome Web Store! - Romain Vialard | Google Apps Script | Scoop.it

"Gmail Meter is now available in the Chrome Web Store!
(and starting in August you'll be able to easily compare your monthly report with the one you have received a month before)"

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

James Ferreiraa Chrome Store App using Google Apps Script, Gmail and Drive to make it easier to bulk print gmail

James Ferreiraa Chrome Store App using Google Apps Script, Gmail and Drive to make it easier to bulk print gmail | Google Apps Script | Scoop.it

James Ferreira has created a Chrome Store App using Google Apps Script, Gmail and Drive to make it easier to bulk print gmails.

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Big Updates for Apps Script - Google Apps Developer Blog

"at Google I/O, we announced many enhancements to Google Apps Script to help you build richer applications and share your apps with users. Apps Script began as a tool for helping users get more done with their Google spreadsheets. Over time, Apps Script has grown to handle much more. It's a platform to extend Google spreadsheets and Sites, and a convenient way to create web applications."

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

script.google.com - Google Apps Script now can run standalone

script.google.com - Google Apps Script now can run standalone | Google Apps Script | Scoop.it
Google Apps Script is a JavaScript cloud scripting language that provides easy ways to automate tasks across Google products and third party services and build web applications.
more...
No comment yet.