Google Apps Script
Follow
Find
70.9K views | +45 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...
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.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Developer Blog: An update to authorization in Apps Script

Google Apps Developer Blog: An update to authorization in Apps Script | Google Apps Script | Scoop.it
For developers, part of the simplicity of Apps Script has always been that authorization requires zero setup — but we heard from users that the process required too many clicks.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Advanced search on Google Sites - Google Apps Script Examples

By default, the search bar in Google Sites let's you search pages & documents on the site. But you can also create a custom search engine with Apps Script and add it to the Google Sites search bar. Here's an example where I let people search for files in a Drive folder:
more...
No comment yet.
Suggested by Shunmugha Sundaram
Scoop.it!

How to Automatically Backup Gmail Drafts to Google Drive Periodically

How to Automatically Backup Gmail Drafts to Google Drive Periodically | Google Apps Script | Scoop.it
Learn how to automatically backup all your Gmail drafts to Google Drive periodically. Never worry about accidentally clicking on discard draft.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

XML changes in Apps Script - Google Apps Developer Blog

"Many developers have come to prefer JSON for data serialization, but we recognize that good ol' XML is still an important format for many Apps Script users. Our existing XML service is good at parsing XML, but has limited ability to create or alter existing documents. In order to provide a more complete and consistent experience, we have created a new XML service, which launches today. The new service is accessed using XmlService, in contrast to the old service which was simply called Xml."

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

MySQL exporter for Google Sheets using Apps Script

If anyone is looking for a MySQL exporter for Google Sheets +Ralf Haring has extended +Pamela Fox 's JSON exporter

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

Canvas API Sheet - Google Apps Script Library/Template to interact with Canvas VLE

Canvas API Sheet - Google Apps Script Library/Template to interact with Canvas VLE | Google Apps Script | Scoop.it

"This is a script to let you populate Google Spreadsheets with Canvas API data" 


Template with the code is here https://docs.google.com/spreadsheet/ccc?key=0AqXrX8DLjV-DdEhTcFVDSTRtOHJsbmQ2VE5IVTBoamc#gid=1


Via @whitmer

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

Jonathon Broughton - Google+ - Graphing social search patterns with d3js and Google Apps Script

Jonathon Broughton - Google+ - Graphing social search patterns with d3js and Google Apps Script | Google Apps Script | Scoop.it
"A d3.js force layout diagram of which of my colleagues are searching for other colleagues"
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Parsing HTML - Google Apps Script Examples

The XML Service can be used to parse HTML. But it can be a bit cumbersome to navigate through the DOM tree. In the examples below we will see how to make that easier with things like getElementById(), getElementsByClassName(), getElementsByTagName().
more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Some common VBA functions translated to Google Apps Script

When converting from VBA, unless you are abandoning VBA, it's just as well to mimic some of the functions that are missing from GAS so that you can minimize you

Via brucemcpherson
more...
brucemcpherson's curator insight, July 10, 2013 3:54 PM

Here's a few of the more common VBA functions translated into javaScript. There a whole bunch more available in a Google Apps Script shareable library here http://ramblings.mcpher.com/Home/excelquirks/gooscript

Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

cDataSet primer - Abstracting Excel and Google Spreadsheet data from physical location

These VBA and Google Apps Script classes abstract data from its location on its underlying worksheet. This means that all procedures that use that data no longe

Via brucemcpherson
more...
brucemcpherson's curator insight, July 4, 2013 7:45 AM

data abstraction primer slides for cDatset classes on VBA and Google Apps Script 

Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Using ScriptDB as a noSQL database for non-Google Apps Script clients

"Here's how to query a scriptDB using 'query by example' and get jSonp results back to any web app."


Via brucemcpherson
more...
brucemcpherson's curator insight, July 9, 2013 1:17 PM

Here's how to query a scriptDB using 'query by example' and get jSonp results back to any web app. 

Scooped by Martin Hawksey
Scoop.it!

Using Google Spreadsheets as a Google Analytics Data Bridge

Using Google Spreadsheets as a Google Analytics Data Bridge | Google Apps Script | Scoop.it

"Access control to Google Analytics data is very coarse. Via the web interface you can have full access or none at all. Given the growing interest in data driven decision making at all levels of the institution I thought it would be beneficial to demonstrate how Google Spreadsheets and Google Apps Script could be used to selectively distribute Google Analytics data."

more...
brucemcpherson's curator insight, July 3, 2013 4:00 AM

Well constructed analytics and google spreadsheets mash up from Martin hawksey