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

Using the Instructure Canvas API with Google Apps Script to extract discussion threads

Using the Instructure Canvas API with Google Apps Script to extract discussion threads | Google Apps Script | Scoop.it

This post contains details of how the Canvas API can be queried with Google Apps Script and the data entered in a Google Spreadsheet. In this particular example I go on to explore the data using Social Network Analysis techniques, but the basic framework may be useful for other projects

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

Localization / Translation Using Google Spreadsheets | vilimblog

"This was an experiment in learning how to use Google Spreadsheets in combination with Google App Scripts to create a localization table that can be accessed via JSON/JSONP. This is useful because there’s still no useful built-in JSON publishing option for individual spreadsheets."

Martin Hawksey's insight:

Nice way to crowd source translations for your Apps Script projects

more...
Ajoy Singh's curator insight, March 25, 12:17 PM

http://www.somyatrans.com/software-localization.html
Software Localization services
Somyatrans is a reliable software localization services across the globe world’s leading brands rely on us for providing professional software localization services. We provide this service at affordable price with high quality, guaranteed accuracy localization services. High-quality software localization ensures that your software "speaks" the language of your customers.

Rescooped by Martin Hawksey from Into the Driver's Seat
Scoop.it!

Google Apps Script: Getting Started Part 2

Google Apps Script: Getting Started Part 2 | Google Apps Script | Scoop.it
In the first Google Apps Script tutorial you learned a little JavaScript to allow you to change the title of a Google Doc. In this tutorial you will create a document and make multiple copies of th...

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

How To: Get Email Notifications When Any Google Document is Updated

How To: Get Email Notifications When Any Google Document is Updated | Google Apps Script | Scoop.it
Learn how to get automatic email notifications when any shared Google document has been updated or edited by someone.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Sheets: Move a row of data to another sheet based on cell value | MASHe

Quick post from me highlighting event objects in Google Apps Script (these are super useful for handling onEdit and other events)

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

inactiveAccountInventory is now public in the Add-ons store for Sheets

inactiveAccountInventory is now public in the Add-ons store for Sheets | Google Apps Script | Scoop.it

"This simple Add-on allows Google Apps domain super-administrators to quickly identify inactive users.

Features include:
- ability to set the threshold number of days that defines user inactivity.
- ability to select and scan only particular Organizational Units

Ideal for use by K-12 schools, where student user inactivity can be indicative of a number of issues that may require targeted intervention."  - Andrew Stillman - Google+

Martin Hawksey's insight:

More awesome work from Andrew Stillman and New Visions for Public Schools

more...
No comment yet.
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.
Rescooped by Martin Hawksey from iGeneration - 21st Century Education
Scoop.it!

Google Apps Script: You Can Code (part 3)

Google Apps Script: You Can Code (part 3) | Google Apps Script | Scoop.it
  Google Apps Script is a great way to get started with learning to program. You need to know very little JavaScript and are able to create really useful projects quickly. For this tutorial we...

Via Tom D'Amico (@TDOttawa)
more...
No comment yet.
Rescooped by Martin Hawksey from Into the Driver's Seat
Scoop.it!

Google Apps Script: Getting Started

Google Apps Script: Getting Started | Google Apps Script | Scoop.it
My new obsession is Google Apps Script. It allows me to add a little code to a Google document to make it do even more magical things! What I was amazed by was how little coding you need to know to...

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

How to monitor trending searches with Google Sheets | Data at GDS

How to monitor trending searches with Google Sheets | Data at GDS | Google Apps Script | Scoop.it
" Using Google Analytics and Google Sheets, you can set up a dashboard to see search terms that people are looking for more than usual. By filtering out searches that are popular all the time, you can focus on what’s new or noteworthy."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Issue 4866: HtmlService NATIVE sandbox mode falls back to EMULATED in Safari and older versions of Chrome

"All clients using NATIVE mode and not updating real-time, seem to loose HtmlService functionality today" - Riël Notermans - Google+

Martin Hawksey's insight:

This issue is being actively worked on by Google Engineers. Click through to this post for a link to the issue ticket and possible workarounds including a suggestion from Steve Webster

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

Changes to OAuth in Apps Script (OAuthConfig deprecated) - Google Apps Developer Blog

The good news:

 

"OAuth is the de facto standard for authorization today and is used by most modern APIs. Apps Script handles the OAuth flow automatically for dozens of built-in and advanced services, but until recentlyonly had limited support for connecting to other OAuth-protected APIs such as Twitter, etc. The URL Fetch service’s OAuthConfig class only works with the older OAuth 1.0 standard and only allows the developer of the script (not its users) to grant access to their data. To address this, we’ve create two new open source libraries"


The bad news: 


"We believe that these open libraries are a better alternative to our previous solution, and therefore we are deprecating the OAuthConfig class. The class will continue to function until June 26, 2015, after which it will be removed completely and any scripts that use it will stop working We’ve prepared a migration guide that walks you through the process of upgrading your existing scripts to use these new libraries."

Martin Hawksey's insight:

Steve Webster kindly highlights "you can open Google Drive and search for "OAuthConfig" to find stand-alone Google Apps Scripts that you need to perform the migration" Note: this won't work for container bound scripts you have included in Forms, Sheets, Docs or Sites

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.