Google Apps Script
Follow
Find
47.1K views | +89 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!

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.
Scooped by Martin Hawksey
Scoop.it!

Automate MailChimp reporting with Google Apps Scripts and Google Spreadsheets

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

Google Apps Script Sprint - 100 Scripts to Get You Started

"This spreadsheet contains an index of 100 scripts you can use to get started with Google Apps Script.

 

Most of the scripts are short, snippets you can customize and combine together. "

Martin Hawksey's insight:

Click title of scoop to open Sheet and make a copy.

more...
No comment yet.
Rescooped by Martin Hawksey from iGeneration - 21st Century Education
Scoop.it!

Archive post - worth a revisit - Top 10 Google Apps Scripts for Education

Archive post - worth a revisit - Top 10 Google Apps Scripts for Education | Google Apps Script | Scoop.it
Top 10 Google Apps Script for Education provided by Synergyse Google Apps Training.

Via Tom D'Amico (@TDOttawa)
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Developer Blog: More Apps Script APIs and Features (including new Document functionality)

Google Apps Developer Blog: More Apps Script APIs and Features (including new Document functionality) | Google Apps Script | Scoop.it
Including new Document Service for named ranges, bookmarks, setting cursor or selection, and undo
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Choosing between Google Apps Script and Google App Engine | Google Apps Experts

"Choosing between Google Apps Script and Google App Engine is not always a clear choice. These two tools are not mutually exclusive in their functionality and could, in many cases, be used conjointly. Fundamentally, they are very similar. Both are platforms on which to build applications, both run within Google's infrastructure and both allow for integration into other Google services. Similarities abound."

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

Google App Scripts for Educators - some starter scripts

Google App Scripts for Educators - some starter scripts | Google Apps Script | Scoop.it
"Recently I went to an ‘Advance Google Session’ at a conference that was conducted by John Warf.  The session was mostly about Google Apps Script (GAS). GAS is a JavaScript cloud scripting language that provides easy ways to automate tasks across Google products and third party services and build web applications.*  GAS lets you do more with Google Apps for Education (GAFE) such as drive and calendars. There a tons of already created scripts that help educators but you can also create your own by opening a Google Doc, spreadsheet etc and clicking on tools, script editor. [Here] is a complied list of the most helpful scripts for educators and links to how-to’s for each one"
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Arun Nagarajan – Google+ - Sidebars in Google Docs and Sheets to be fixed to be 300px

Arun Nagarajan – Google+ - Sidebars in Google Docs and Sheets to be fixed to be 300px | Google Apps Script | Scoop.it
"Quick update - going forward sidebars in Google Docs and Sheets will be forced to be 300px. If you have code that sets width of a sidebar, that call will be ignored. Please update your UI accordingly. This change has already been rolled out to new Sheets and will be in Docs next week.  If you were never setting width, then you'll notice no difference as the default was 300px. "
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Collaborative Tools Project: A Simple Example Booking Project in Google Spreadsheets

Collaborative Tools Project: A Simple Example Booking Project in Google Spreadsheets | Google Apps Script | Scoop.it
more...
No comment yet.
Rescooped by Martin Hawksey from Excel Liberation
Scoop.it!

Are the new Google Sheets faster than the old?

Are the new Google Sheets faster than the old? | Google Apps Script | Scoop.it

Via brucemcpherson
Martin Hawksey's insight:

What's interesting is in the new Sheets known issues it states "Some methods, most notably batch-set methods like Range.setValues(), are currently slow in the new version of Sheets." https://developers.google.com/apps-script/migration/sheets#performance ... so slow but still faster???

more...
brucemcpherson's curator insight, January 27, 11:03 AM

Good speed improvement for writing data in the new Google Sheets.

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.
Scooped by Martin Hawksey
Scoop.it!

Recreate SharePoint lists in Google Apps, with both bulk editing and edit form functionality

Recreate SharePoint lists in Google Apps, with both bulk editing and edit form functionality | Google Apps Script | Scoop.it

"This solution came about from a requirement to recreate SharePoint lists in Google Apps, taking across large numbers of list items, with each item needing to have  its own edit form populated with the appropriate data. Additionally, users should be able to edit the Google Sheet, and have those changes reflected in the edit forms. This attempts to give the same functionality as SharePoint where items can be edited in edit form, or in bulk via datasheet view"

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

Building a Google Apps Script Polling App | Eforcers S.A.

Building a Google Apps Script Polling App | Eforcers S.A. | Google Apps Script | Scoop.it
Martin Hawksey's insight:

Nice tutorial to help new users understand the Apps Script coding environment

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

Eric Koleda - Google+ - Google Apps Script: How to determine if a range within a Google Doc contains a given position

Eric Koleda - Google+ - Google Apps Script: How to determine if a range within a Google Doc contains a given position | Google Apps Script | Scoop.it

"Wanted to share a little code snippet I cooked up today. It provides a function you can use to determine if a given Position with a Google Doc is contained within a given Range. This can be useful when using the new NamedRange functionality we launched yesterday (http://goo.gl/eiCXXP) and want to determine if the user's cursor falls within one of those ranges."

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

Tracking Google Sheet views with Google Analytics using GA Beacon

Tracking Google Sheet views with Google Analytics using GA Beacon | Google Apps Script | Scoop.it
This post describes how you can use the IMAGE formula as a Google Analytics Beacon for tracking Google Sheets views
Martin Hawksey's insight:

I've got quite a few Google Sheet templates in the wild and was looking for a way to track usage (even just a basic view count). Recently I came across +Ilya Grigorik 's Google Analytics Beacon project which lets you use an image as a GA webbug. The result basic Google Analytics tracking of sheets without jumping through potential Google Apps Script authorisation and quota issues  

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

Arun Nagarajan - Google+ - early announcement deprecation of Finance and Property Service

Arun Nagarajan - Google+ - early announcement deprecation of Finance and Property Service | Google Apps Script | Scoop.it

"Finance Service - we are deprecating the Finance Service in Google Apps Script. It will remain available for the next six months but will be turned off on September 26, 2014. Please start considering alternatives for the financial data right away. 

Properties Service - we are launching a new properties service with a notion of Document level properties and more. Due to this, we will be deprecating the current properties service. Again, stay tuned for more details tomorrow! We think you'll like the new Properties service look. This is more of a heads up. No action needed till after tomorrow's blog post. "

Martin Hawksey's insight:

Also some goodies to be announced tomorrow on http://googleappsdeveloper.blogspot.com/

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

Amit Agarwal – Google+ - More resources for learning Google Apps Script

Amit Agarwal – Google+ - More resources for learning Google Apps Script | Google Apps Script | Scoop.it

0. https://developers.google.com/apps-script/case-studies ;
1. http://www.scoop.it/t/gas - by +Martin Hawksey  
2. http://www.labnol.org/internet/google-scripts/28281/ - by +Amit Agarwal 
3. scriptsexamples - by +Romain Vialard 
4. http://shop.oreilly.com/product/0636920032557.do - by +James Ferreira 
5. http://www.youtube.com/playlist?list=PLB18FD78D51BDF5D3 - by +Eric Koleda and +Arun Nagarajan 

Martin Hawksey's insight:

Thank you Amit Agarwal for highlighting 'The GAS'

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

Google Docs/Drive - auto number Document headings

Google Docs/Drive - auto number Document headings | Google Apps Script | Scoop.it

Stackoverflow answer for auto numbering Google Documents headings with Google Apps Script

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

GAS Library Box - Google Apps Script Hacks

GAS Library Box - Google Apps Script Hacks | Google Apps Script | Scoop.it
GAS Library Box is a Chrome Extension for managing Apps Script libraries. Install the extension and get an auto-complete box when adding a managed library to your Script project.
more...
No comment yet.