Google Apps Script
Follow
Find
46.5K views | +97 today
Suggested by Jacob Jan Tuinstra
onto Google Apps Script
Scoop.it!

Code-Infection Blog: Google Calendar and Google Apps Script by Balazs Nadasdi

Code-Infection Blog: Google Calendar and Google Apps Script by  Balazs Nadasdi | Google Apps Script | Scoop.it

Manage overtime with google calendar and drive with google apps script

 

via Jacob Jan Tuinstra

more...
No comment yet.
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...
Rescooped by Martin Hawksey from Excel Liberation
Scoop.it!

Database abstraction with google apps script - Desktop Liberation

Database abstraction with google apps script - Desktop Liberation | Google Apps Script | Scoop.it
brucemcpherson's insight:

"Sometimes you start with a particular database, or a spreadsheet, then you decide to use something else, and you have to refactor all your code. This is an early version of a Google Apps Script handler for database abstraction (with of course a heavy focus on Google options), to try to avoid some of that pain. "


Via brucemcpherson
more...
brucemcpherson's curator insight, April 7, 12:20 PM

Sometimes you start with a particular database, or a spreadsheet, then you decide to use something else, and you have to refactor all your code. This is an early version of a Google Apps Script handler for database abstraction (with of course a heavy focus on Google options), to try to avoid some of that pain. 

Scooped by Martin Hawksey
Scoop.it!

Lenny Cunningham - Google+ - Google Apps Script Garage Door Opener

Lenny Cunningham - Google+ - Google Apps Script Garage Door Opener | Google Apps Script | Scoop.it

"Had a couple free moments this weekend and decided to use Apps Script in part of my Home Automation.  Here you go hopefully the first #appsscript  Garage Door Opener with a +ControlByWeb Dual Relay"

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

Custom Emails from a Spreadsheet: Humanizing the Google Apps Script

Custom Emails from a Spreadsheet: Humanizing the Google Apps Script | Google Apps Script | Scoop.it

"For non-technical people venturing into the startup space, tools like Excel might be more familiar than JavaScript. The Google Apps Script is a JavaScript-based language that allows you to easily do amazing things with Google Docs, Sheets, and Forms. Google Developers has a very good tutorial on sending emails from a spreadsheet.

 

This guide expands on the script, allowing you to customize the emails to be more personal. "

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

Google Docs Add-ons: Notes for Google Apps Admins

Google Docs Add-ons: Notes for Google Apps Admins | Google Apps Script | Scoop.it
Google recently announced the release of add-ons for Google Docs and new Sheets. This post provides some notes for Google Apps admins about their use
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

[Book] Google Apps Script: Web Application Development Essentials, 2 Ed.

[Book] Google Apps Script: Web Application Development Essentials, 2 Ed. | Google Apps Script | Scoop.it

"Learn how to create dynamic web applications with Google Apps Script and take full advantage of your Google-hosted services. If you have basic coding skills and some JavaScript experience, this practical book shows you how Apps Script works, and provides step-by-step guidance for building applications you can use right away."

Martin Hawksey's insight:

James Ferreira is back with the 2nd Edition of Google Apps Script: Web Application Development Essentials. The book is in 'early release' which gives you access to it while it's been written. Given the number of Apps Script updates I imagine this will keep James busy. 

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

Will Welch - Google+ - Resource Reservation System Google Apps Script

Will Welch - Google+ - Resource Reservation System Google Apps Script | Google Apps Script | Scoop.it

Resource reserving script from Will Welch

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

Google Apps Script-let for timestamping a Google Document footer

Google Apps Script-let for timestamping a Google Document footer

Martin Hawksey's insight:

A number of ways you could improve this by adding to an 'on' event or wrapping in a add-on

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

Google Apps Script Add-ons Reviewed - YouTube

Google Apps Script Add-ons Reviewed - YouTube | Google Apps Script | Scoop.it
Martin Hawksey's insight:

In these Google Developers Live sessions Arun Nagarajan highlights some of the Add-ons already available in Google Documents and Sheets taking time to speak to their creators.

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

Bruce Mcpherson: Google Developer Expert (GDE) Apps Script

Bruce Mcpherson: Google Developer Expert (GDE) Apps Script | Google Apps Script | Scoop.it

"It's a great feeling to have your work recognised in this way, even though I do feel a little out of place in the company of the august group who make up the current GDE community. GDEs are a small, but enthusiastic group who share a passion for the family of Google APIs and products, and give generously of their time to share their knowledge and ideas with others."

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

Martin Hawksey: Google Developers Experts (GDE) Apps Script

Martin Hawksey: Google Developers Experts (GDE) Apps Script | Google Apps Script | Scoop.it

"Having recently be recognised as a Google Developers Experts for Google Apps Script I highlight my hacker roots"

Martin Hawksey's insight:

So as well becoming ALT’s Chief Innovation, Technology and Community Officer I've recently been recognised as a Google Developers Experts (GDE) :)

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

Eric Koleda shares an example of how to wrap old custom functions into a Google Add-on

Eric Koleda shares an example of how to wrap old custom functions into a Google Add-on | Google Apps Script | Scoop.it

"One of add-ons that launched yesterday was Date Add and Subtract, a sample add-on we created on the Apps Script Developer Relations team. It provides a couple of custom functions for date manipulation and was built to show how you can move your custom functions scripts to the add-ons framework.

The full source code (there isn't much) is now available on GitHub: http://goo.gl/6N8Pdw. There is a wealth of custom functions in the Script Gallery that we would love to see start moving to the add-on store, so get cracking and fill our the add-on application form (http://goo.gl/qBCs09) when you've got something working."

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

How to Write an Add-on for Google Docs

How to Write an Add-on for Google Docs | Google Apps Script | Scoop.it

"Google Add-ons add new capabilities to Google Docs and Sheets. This video tutorial explains how you can create your own Google add-ons using HTML, CSS and JavaScript."

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

GASRetry - Exponential backoff JavaScript implementation for Google Apps Script by Peter Herrmann

"Invokes a function, performing up to 5 retries with exponential backoff. Retries with delays of approximately 1, 2, 4, 8 then 16 seconds for a total of about 32 seconds before it gives up and rethrows the last error."
more...
No comment yet.
Rescooped by Martin Hawksey from Excel Liberation
Scoop.it!

pollHandler app and library - Desktop Liberation

pollHandler app and library - Desktop Liberation | Google Apps Script | Scoop.it

Polling app based on Google Apps Script


Via brucemcpherson
more...
brucemcpherson's curator insight, April 10, 2:28 PM

Here's the all you need for a simple Poll app based on a Google Apps Script webapp handling a parse.com database, Google Charts and a javascript client.

Scooped by Martin Hawksey
Scoop.it!

Apps Script: Login Activities Dashboard - Revisited - Google Drive

"Ever wanted to have a quick glance at the distribution of login activities in your domain? Check out this revisted script with more data/fields, and more reporting time periods!


You can use this script to get valuable information about your user community including WHO is logging in, WHERE and HOW they are authenticating to Google Apps and their login challenges. You can then share this information with your Support team to prepare them for end user issues."


By +Justin Gale 

Martin Hawksey's insight:

+Justin Gale has a lovely script and setup instructions for a  'Login Activities Dashboard'. Lots of scope to extend this to selectively release slices of the data to school admins or incorporate in a wider #learninganalytics solution

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

Cache 101 with Google Apps Script: Breaking the 100kb cache limit)

"If you have used the cache service long enough in your Google Apps Script, you probably have known you could not cache anything larger than 100KB. 


Here is a simple ready-to-use wrapper which hides the complexity and still performs equally well for size under 100KB."

Martin Hawksey's insight:

From the comments of this post Chris Morris also provides a modified version https://docs.google.com/document/d/1c276AZNkicfX0PmyaZS2OSebrU84XmQHvHq9XZUMGWY/edit?usp=sharing


HT +Jacob Jan Tuinstra for highlighting

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

Developing add-ons for Google Docs/Sheets/Forms - Community - Google+

Developing add-ons for Google Docs/Sheets/Forms - Community - Google+ | Google Apps Script | Scoop.it

"Add-ons are tools created by developers that literally add on new capabilities to Google Docs and Sheets (Forms add-ons are coming soon). They should focus on the end-user and provide problem-solving solutions that help them be more productive with a beautiful and professional appearance. Besides coding, there are Google guidelines to consider, creating a professional support website, publishing to the Chrome Web Store, and strategizing a marketing plan."

Martin Hawksey's insight:

New Google+ community for everyone interested in developing add-ons for Google Drive using Google Apps Script

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

Speaking JavaScript: Free O'Reilly eBook for better Google Apps Scripting

Speaking JavaScript: Free O'Reilly eBook for better Google Apps Scripting | Google Apps Script | Scoop.it

"This book has been written for programmers, by a programmer. So, in order to understand it, you should already know object-oriented programming, for example, via a mainstream programming language such as Java, PHP, C++, Python, Ruby, Objective-C, C#, or Perl.

 

Thus, the book’s target audience is programmers who want to learn JavaScript quickly and properly, and JavaScript programmers who want to deepen their skills and/or look up specific topics."

Martin Hawksey's insight:

Given many Apps Scripters may be coming from other programming languages (and given Google Apps Script uses a JavaScript syntax) this could be an ideal resource. 

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

Sorting bookmarks in a document - Excel Liberation

Sorting bookmarks in a document - Excel Liberation | Google Apps Script | Scoop.it
"Here's how to sort bookmarks into position order in a document.  We'll use Advanced Array functions heavily here"
more...
No comment yet.
Rescooped by Martin Hawksey from iGeneration - 21st Century Education
Scoop.it!

Your First Google Apps Script

Your First Google Apps Script | Google Apps Script | Scoop.it
Google Apps Script is a JavaScript-based scripting language that you can use to automate tasks in Google Docs, Sheets, and Forms. There s no extra software to be installed, as there s a code editor provided in Google Drive.

Via Tom D'Amico (@TDOttawa)
more...
iCoachP53's curator insight, March 19, 8:43 AM

You probably have know idea what a "Google Script is"  but you should.  They can make your life much easier.  #edtech

Scooped by Martin Hawksey
Scoop.it!

Mr. Hay's Technology: Google Apps Script: Auto-Query FortiGuard Category List

"a little Google Apps Script I put together for querying FortiGuard's Web Filtering Service site category list from a spreadsheet. It takes a URL from the selected cell in a Google Spreadsheet, and replaces it with FortiGuard's category for that URL."

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

Google+ Flubaroo add-on for Google Sheets

Google+ Flubaroo add-on for Google Sheets | Google Apps Script | Scoop.it
Flubaroo add-on for Google Sheets A favorite among teachers, Flubaroo is now even easier to use. With add-ons in Sheets, quickly grade and analyze student performance on multiple choice and fill-in assignments. Designed by a teacher, for teachers, Flubaroo is easy to use. Try it today for your assignments, quizzes, assessments, or even an exam. http://goo.gl/DralHr
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Automating Google Services with Google Apps Script - Sample Book Chapter

Automating Google Services with Google Apps Script - Sample Book Chapter | Google Apps Script | Scoop.it

Sample chapter published

Martin Hawksey's insight:

Interesting to see more books coming out to support people interested in Google Apps Script. Latest one is being put together by +Douglas Starnes hosted on leanpub (sample chapter included). 

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

Scripts are for Kids, too! 16 year old Tim Cargan's redevelopment of the autoCrat add-on

Scripts are for Kids, too! 16 year old Tim Cargan's redevelopment of the autoCrat add-on | Google Apps Script | Scoop.it
Martin Hawksey's insight:

Lovely story to come out as a result of the Google Docs and Sheets add-ons highlighting the power of our hyper-connected world and what is possible with students as producers. 

Read how 16 year-old Tim Cargan volunteered his time to redevelop autoCrat as a Google Docs Add-ons

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

Build add-ons for Google Docs and Sheets - Google Apps Developer Blog

Build add-ons for Google Docs and Sheets - Google Apps Developer Blog | Google Apps Script | Scoop.it
"Eric Koleda originally shared: The evolution of Apps Script is here!

With add-ons you can write code once, distribute it to millions of Docs and Sheets users in an eye-catching store, and push updates out seamlessly. All the tools you need to get started writing your own add-on are available today, but for the time being you'll need to go through a approval process before you can publish it. "
Martin Hawksey's insight:

already some very cool looking add-ons like Amit Agarwal

Twitter Curator for Google Docs https://chrome.google.com/webstore/detail/twitter-curator/hodbfgbgmlpghbijbelkdmgjocohhhkp
more...
No comment yet.