Google Apps Script
Follow
Find
68.1K views | +72 today
 
Scooped by Martin Hawksey
onto Google Apps Script
Scoop.it!

Jellybend.com - Google Apps Script help and support (and loads of script examples)

Jellybend.com - Google Apps Script help and support (and loads of script examples) | Google Apps Script | Scoop.it
Jellybend.com provides Google Apps Scripts help and support to automate tasks across Google products and third party services.
Martin Hawksey's insight:

I've been struggling to keep up to date with the examples Marcello Scacchetti and the other folks at Jellybend have been up to. Check their blog for examples on creating custom forms, sales tracking, merging Google Documents, syncing contacts and more

more...
No comment yet.

From around the web

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...
Your new post is loading...
Scooped by Martin Hawksey
Scoop.it!

Google Apps Script Form Class has been updated

Google Apps Script Form Class has been updated | Google Apps Script | Scoop.it
Google Apps Script have been updated. The Form Class have been added some new methods.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

RipDB - scriptDB emulator for Google Apps Script

"If you still have some old small projects written for ScriptDB that you didn't get round to converting yet, then here's a library that's a complete recreation of the ScriptDB syntax, except that it uses dbAbstraction back end - so you pick whatever platform you prefer and your old ScriptDB code should work with not a lot of modification." 

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

Google Apps Script .gs files are now recognised as JavaScript in Github editor

"For all you people who get round to loading your GAS libraries and snippets onto Github (since made a lot easier thanks to +Bruce Mcpherson  and his GasGit) I've just noticed that the code editor in Github now recognises .gs files as JavaScript, rather than Gosu, so we don't have to rename them all to .js files." +Andrew Roberts

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

Edouard Brasier - Google Apps Expenses Manager

"This is a case study illustrating the use of Google Apps Script to drive Finance Change. The application allows businesses to efficiently manage their expenses saving on processing time and reducing mileage fraud. "

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

Google Hangout On Air Recording: Using Google Apps Script for Education

"Learn how to add power to Google Apps with a little bit of programming: automate test grading, domain administration, and more with Apps Script and Add-Ons! "

Martin Hawksey's insight:

The recording of this session has the accompanying slide deck http://goo.gl/cCgGpc

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

Revisiting issuing Mozilla Open Badges with Google Apps Script and Google Sites: Notes on new options | MASHe

Revisiting issuing Mozilla Open Badges with Google Apps Script and Google Sites: Notes on new options | MASHe | Google Apps Script | Scoop.it
A post looking at what's possible in terms of issuing Open Badges using only Google Apps Script
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Getting your apps scripts to Github - Desktop Liberation

Getting your apps scripts to Github - Desktop Liberation | Google Apps Script | Scoop.it
"You can get all your apps scripts, libraries and dependencies up to git hub and documented automatically with this apps script project. No need for local files as everything happens on drive, and no need for local git software or any particular OS as it all happens with the github API." - Bruce MacPherson
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Free Technology for Teachers: 10 Good Google Docs, Sheets, and Forms Add-ons for Teachers

Free Technology for Teachers: 10 Good Google Docs, Sheets, and Forms Add-ons for Teachers | Google Apps Script | Scoop.it
" This afternoon I was asked if I could put together a list of my favorite Google Docs, Sheets, and Forms Add-ons. In the past I had put together lists of Sheets scripts, but most of those lists are outdated as Add-ons have mostly replaced scripts. Here's my updated list of my favorite Google Docs, Sheets and Forms Add-ons."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Some best practise notes on DbAbstraction usage

Some best practise notes on DbAbstraction usage | Google Apps Script | Scoop.it

"Since we have a lot of operations going through the database abstraction libraries nowadays (over 3 million since I released this in summer last year),  I thought I'd give a few hints."

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

Real-time logs analysis using Fluentd and BigQuery

Real-time logs analysis using Fluentd and BigQuery | Google Apps Script | Scoop.it
Mandy Waite "A new tutorial for doing real-time logs analysis with with Fluentd and Google BigQuery. Covers the following steps (requires some billable components of Google Cloud Platform):  - Run an nginx web server in a Google Compute Engine instance.  - Log browser traffic to that server using Fluentd.  - Query the logged data using the BigQuery web UI and using Google Apps Script from a Google Spreadsheet.  - Visualize the query results in a chart within a Google Spreadsheet that automatically refreshes."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

An update on the migration of older spreadsheets to the new Google Sheets

An update on the migration of older spreadsheets to the new Google Sheets | Google Apps Script | Scoop.it

"Back in November 2014, we announced that older spreadsheets (those created prior to Dec 2013, including any subsequent copies) would start being gradually migrated to the new version of Google Sheets for Google Apps domains on the Rapid release track, with Scheduled domains to follow

...Simpler spreadsheets will be upgraded first, while those that use Apps Script and more complex features will be migrated weeks to months later to ensure a seamless transition."

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

Checking the argument types in Google Apps Script - Desktop Liberation

"Function to check the type of Apps Script function arguments at run time against what you intend them to be"

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

SignaturesManager for Google Apps Script

SignaturesManager for Google Apps Script | Google Apps Script | Scoop.it
appsscript-signaturesmanager - A library that provides the ability to manage the signatures of Google Apps users in Google Apps Script.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Tutorial: Interacting With Your Google Drive with Apps Script (including reading/writing .csv files) | MASHe

Tutorial: Interacting With Your Google Drive with Apps Script (including reading/writing .csv files) | MASHe | Google Apps Script | Scoop.it

A question came in on the Google Apps Script Google+ Community which in part was asking about parsing .csv files into a Google Sheet. I initially pointed the asker to some dated documentation so for my penance I've updated it.

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

Add Ons & Apps Script | The Apps Show - YouTube

"Debbie and John take it to the next level with Google Apps Script. With Apps Script, you can create add-ons for Google Sheets, Docs, or Forms, automate your workflow, integrate with external APIs, and more."

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

New Google Add-on: inactiveAccountInventory - helps domain admins to identify users who aren't logging in

New Google Add-on: inactiveAccountInventory - helps domain admins to identify users who aren't logging in | Google Apps Script | Scoop.it
"Introducing inactiveAccountInventory - a very simple Add-on for GAFE domain admins to identify users who just aren't logging in! This Add-on was primarily built to help schools serving high-needs student populations identify and intervene around inequities in student account usage."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Set an Auto-Expiry Date for Shared Files and Folders in Google Drive

Set an Auto-Expiry Date for Shared Files and Folders in Google Drive | Google Apps Script | Scoop.it
You can set an expiry date for your shared folders and files in Google Drive and the shared links will automatically get disabled at the specified date and time.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Launchpad Online: Intro dev video tutorials

Launchpad Online: Intro dev video tutorials | Google Apps Script | Scoop.it
"In the 2015 kick off episode (http://goo.gl/oAzBN9) of the Launchpad Online developer video series (http://goo.gl/kFMUa6), Google engineer +wesley chun shows you how to connect to Google Maps from a spreadsheet! This isn't a party trick... you’ll learn how to do this, why it may be something useful to consider, and have real working code by the time you’re done. In an earlier video (http://goo.gl/1sXeuD), we introduced viewers to Google Apps Script (http://developers.google.com/apps-script), our cloud-based #JavaScript environment giving developers access to Google Apps data as well as other Google services. In this sequel, we'll take your skills to the next level, creating a map based on a street address in a Google Sheet. And maybe, if you hang in till the end, we'll have an surprise bonus for you!"
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Developers Blog: Control protected ranges and sheets in Google Sheets with Apps Script

Google Developers Blog: Control protected ranges and sheets in Google Sheets with Apps Script | Google Apps Script | Scoop.it

"A few weeks ago, the Google Sheets team introduced improved control over protected sheets and ranges. Developers have told us they're looking for the same power in Google Apps Script — after all, ever since we added data validation to the Spreadsheet service, programmatic control over protected ranges has been the most popular request on the Apps Script issue tracker.

Today, we are excited to give you that granular control.

With the new Protection class in the Spreadsheet service, your scripts can touch every aspect of range or sheet protection, just like in the new UI. (The older PageProtection class, which had more limited features, will be deprecated, but will stick around in case you need to work with older spreadsheets. The new Protection class only applies to the newer version of Sheets.)"

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

Sites Catalog - Google Apps Script Examples

Sites Catalog - Google Apps Script Examples | Google Apps Script | Scoop.it
The add-on Sites Catalog lists all the Google Sites a user has access to. Google Apps administrators (full admin) can list all sites created on their Google Apps domain
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Oauth2 step by step - apps script authentication for the Google Drive JSON API - Desktop Liberation

Oauth2 step by step - apps script authentication for the Google Drive JSON API - Desktop Liberation | Google Apps Script | Scoop.it
more...
No comment yet.