Google Apps Script
Follow
Find
76.6K views | +53 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...
Your new post is loading...
Scooped by Martin Hawksey
Scoop.it!

Collaborative Tools Project: Emailing Someone a Fancy PDF When They Submit a Google Form

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

CesarsTechInsights: How to easily use BigQuery's Querys & Charts with Google Apps Script! (and our FREE library)

CesarsTechInsights: How to easily use BigQuery's Querys & Charts with Google Apps Script! (and our FREE library) | Google Apps Script | Scoop.it
How to easily use BigQuery's Querys draw it using Google Charts with Google Apps Script! includes a Free Library to help you setup your querys faster.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Awesome Things You Can Do With Google Scripts

Awesome Things You Can Do With Google Scripts | Google Apps Script | Scoop.it
A collection of top Google Scripts for Gmail, Google Drive, Calendar, Contacts and other Google services. No programming knowledge required to run the scripts.
Martin Hawksey's insight:

Amit Agarwal shares over 30 of his script projects (with some guest contrubutions) showing the wide range of problems you can solve with Google Apps Script

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

PJ's Development: Google Drive - Bulk letter generation (with Google Apps Script)

Martin Hawksey's insight:

Via +Jacob Jan Tuinstra

more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Validation and lookups using shared google apps scriptDB lists


Via brucemcpherson
more...
brucemcpherson's curator insight, September 19, 2013 7:13 PM

Here's how to access shared lists across workbooks using vlookup, index and match style functions, and how to use those same lists to create and apply dynamic dataValidation to Google Spreadsheets.

Scooped by Martin Hawksey
Scoop.it!

Useful Google Spreadsheet Script Triggers | Railsware Blog

Useful Google Spreadsheet Script Triggers | Railsware Blog | Google Apps Script | Scoop.it
"In my previous blog post, I've provided a brief intro to Google Scripts and with this article, I'd like to share several useful code examples that might come"
more...
No comment yet.
Rescooped by Martin Hawksey from New Web 2.0 tools for education
Scoop.it!

Goobric Walkthrough

Goobric is a Chrome extension that works as part of the Doctopus Google Apps Script written by Andrew Stillman. It allows teachers to attach a rubric to each...

Via Kathleen Cercone
more...
Jonathan Jarc's curator insight, August 12, 2013 12:06 PM

Great in conjunction with Doctopus. Highly recommended.

mmarotta's curator insight, November 27, 2013 1:20 PM

Testing out with SWR this week

 

Suggested by Shunmugha Sundaram
Scoop.it!

Shared Google Tasks: How to Share and Sync your Task List with Others

Shared Google Tasks: How to Share and Sync your Task List with Others | Google Apps Script | Scoop.it
Learn how you can share and sync your Google Task Lists with others and always keep them up-to-date with Shared Google Tasks app.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Eforcers S.A.: Building a Google Apps Script Web App, Part 1 (polling app tutorial)

Eforcers S.A.: Building a Google Apps Script Web App, Part 1 (polling app tutorial) | Google Apps Script | Scoop.it
Nice little tutorial for Google Apps Script making a polling app using ScriptDb and HTML Service
more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

What does Google Autocomplete show all over the world? (Google Apps Script)


Via brucemcpherson
Martin Hawksey's insight:

Nice clean example from Bruce Mcpherson of how you can get a spreadsheet of Google Autocomplete suggestions for different language codes. I'm wonder what other localisation parameters can be added to the query like 

cr=countryZA to limit suggestions from South Africa?

more...
brucemcpherson's curator insight, August 9, 2013 1:49 PM

Here's an interesting Google Spreadsheet. Give it the beginning of a query, supply a list of languages, and you'll get the Google autocomplete suggestions for that query in each of the countries associated with the language,

Scooped by Martin Hawksey
Scoop.it!

Jonathon Broughton - Google+ - Starting my daughter (age 5.5) with Apps Script.

Jonathon Broughton - Google+ - Starting my daughter (age 5.5) with Apps Script. | Google Apps Script | Scoop.it

"Starting my daughter (age 5.5) with Apps Script.

She has become a good 3D modeller and enjoys 3D printing.

Together we are working on an idea she has for using the days weather to generate shapes. We'll probably use Processing first which she likes for making 2D art from data then move onto Grasshopper3D for Rhino. "

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

Rafael Chaves - Google+ - A simple way of monitoring status of websites with Google App Script

Rafael Chaves - Google+ - A simple way of monitoring status of websites with Google App Script | Google Apps Script | Scoop.it

"Needed a simple way of monitoring status one or more websites. This is what I cobbled up together, if you have a Google Drive account, feel free to copy, modify and deploy using Google Apps Script:"

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

Google Spreadsheet: How to compare two strings and highlight the differences

Google Spreadsheet: How to compare two strings and highlight the differences | Google Apps Script | Scoop.it
How to compare two strings character by character in Google Spreadsheets using Google Apps Script or built-in Google Sheet formula
more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Scriptdb - not just for Google Apps Script

Scriptdb is a no-sql db associated with each Google Apps Script. Here's some unusual uses - it's a useful db in its own right.

Via brucemcpherson
more...
No comment yet.
Rescooped by Martin Hawksey from Google Product News
Scoop.it!

Total Eclipse of the Apps Script [Google Apps Developer Blog]

Total Eclipse of the Apps Script [Google Apps Developer Blog] | Google Apps Script | Scoop.it
Apps Script started out as a simple tool to let developers add new features to Google Apps, but it’s grown into a programming platform that thousands of professional coders use every day.

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

DJ's Weblog » Blog Archive » SheetAsJSON – Google Spreadsheet Data as JSON

DJ's Weblog » Blog Archive » SheetAsJSON – Google Spreadsheet Data as JSON | Google Apps Script | Scoop.it
"This is a short post to explain how to expose a ‘typical’ Google spreadsheet (rows of columnar data, with first header row) as JSON, via HTTP"
more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Excel Liberation.: Excel custom functions that can lookup data in Google Apps Script ScriptDB

Excel Liberation.: Excel custom functions that can lookup data in Google Apps Script ScriptDB | Google Apps Script | Scoop.it

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

Apps Script Development for Google Sites by Santiago Montesdeoca

Apps Script Development for Google Sites by Santiago Montesdeoca | Google Apps Script | Scoop.it
"We created a little Apps Script Development guide for Google Sites. Please feel free to leave comments in the document."
more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

GAS lists and validation - Excel Liberation

GAS lists and validation - Excel Liberation | Google Apps Script | Scoop.it

Vlookup, index, match and other stuff where the lists are not in your spreadsheet, but shared from Google Apps ScriptDB


Via brucemcpherson
more...
brucemcpherson's curator insight, August 14, 2013 2:49 PM

It's very common to want to lookup some list, or apply them as validation to data entry when playing around with Spreadsheets. 

 For something so common, we spend a lot  of time copying lists between spreadsheets, or figuring out ways of getting them from databases or shared workbooks. These lists could be pretty stable - used by the whole world (for example lists of countries), within a company (eg. branch addresses), within a department (eg stock list), or belonging to an individual (eg list of telephone numbers). Here's a start on sharing lists out from scriptDB
Scooped by Martin Hawksey
Scoop.it!

gFormGitTicket: Using Google Apps Script to let users submit issue tickets to Github anonymously

gFormGitTicket: Using Google Apps Script to let users submit issue tickets to Github anonymously | Google Apps Script | Scoop.it
gFormGitTicket - Snippet and demonstration of Google Apps Script snippet that let you use a Google Form to anonymously open Github Issue tickets
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Using Google Apps Script to visualise and share Github commit data #YRS2013

Using Google Apps Script to visualise and share Github commit data #YRS2013 | Google Apps Script | Scoop.it
" spreadsheet tracking all of the 2013 hacks that had declared a Github repo in their information pages. You can see that there are a massive number of kids not only hacking code but sharing it with the world"
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Script | The Programmer's Library

Code Snippets, Scripts, Video Tutorials and Programming Books for Google Apps Script
more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Answering another top request: data validation in Apps Script - Google Apps Developer Blog

Answering another top request: data validation in Apps Script - Google Apps Developer Blog | Google Apps Script | Scoop.it
For the last few months, scriptable access to the data validation feature in Sheets has been the most requested feature on the Apps Script issue tracker.

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

Create Basecamp To-Do Items From a Google Spreadsheet

Create Basecamp To-Do Items From a Google Spreadsheet | Google Apps Script | Scoop.it
"integrating some Google Spreadsheets with Basecamp Classic using the rest API"
more...
No comment yet.