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

Collaborative Tools Project: 2. Building a Booking System With Google AppScript...

Collaborative Tools Project: 2. Building a Booking System With Google AppScript... | Google Apps Script | Scoop.it
"Given the swingeing criteria in my first post, I decided to start by creating the simplest interface I could.

I began with a simple database of Perches in a spreadsheet and then in the Script Editor created a rough GUI with a couple of dropdown menus, and a couple of buttons that I would fill with data from the a mixture of a Perches calendar and this spreadsheet.

I decided not to keep track of bookings in a separate spreadsheet, simply because this felt like it would just be a whole heap of work. I would just use a calendar to store bookings. The guest of each event would decide who's booking it was."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google in Education - Google+ - Interested in automating processes within Google Apps Script?

Google in Education - Google+ - Interested in automating processes within Google Apps Script? | Google Apps Script | Scoop.it

Interested in automating processes within Google Apps? Want to learn more about what powers Flubaroo? Then Apps Script is for you! Tune into our Hangout on Air on Wednesday May 23 11am-12pm PT with +Eric Koleda who will be sharing an introduction to Apps Script, use cases, code examples, and holding Q&A.

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

Get the revision history of a resource using DocsList API - Apps Script Tutorial

"To get the revision history of your resource in your Google Docs using Google Apps Script, you can use Google DocsList API with Google oAuth and URLFetch App."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Insider Tips for Using Apps Script and Spreadsheets - Google Apps Developer Blog

"My role in Google Docs is to help manage many projects across Google Docs/Drive. As a part of my job, I ask for a fair amount of data from all of those teams and generate reports on project/feature status. To make this much simpler for everyone involved, I have created a lot of simple tools using Google Spreadsheets and Apps Script (as well as a lot of complex tools) that make it easier for collaborators to enter data and for me to collect that data and create reports. Below is a pair of foundational techniques that I include in nearly every Spreadsheet/Apps Script tool I build."

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

Official: Google Apps Script community support is moving to Stack Overflow!

Message from Anton Soradoi (Google Employee):

 

"Hello Apps Script Community,

In the last few years, the Q&A website Stack Overflow has become an invaluable tool for developer communities. We’re pleased to announce that we are migrating to Stack Overflow as the official channel for answering development questions about Google Apps Script.

 

We believe that Stack Overflow is the perfect venue to grow the Apps Script developer community. Google employees and Apps Script Top Contributors will actively participate on the StackOverflow tag google-apps-script. We aim to provide a great community experience there, with more relevant questions and answers, and a strong group of community experts.

 

Due to Stack Overflow’s use of OpenID for account management, you will not need to create a new account to participate in the discussion - you will be able to log in with any of the identity providers supported by Stack Overflow, including Google Accounts.

 

Effective Monday, May 7, new questions should be posted to Stack Overflow. This forum will be in moderated mode for a short time so that existing issues can be resolved, but shortly after that, it will be moved to read-only and maintained as an archive. Thank you all for your membership and contributions."

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

Send your Gmail Attachments to Google Drive With a Click using Apps Script

Send your Gmail Attachments to Google Drive With a Click using Apps Script | Google Apps Script | Scoop.it

"Imagine this. You are reading a Gmail message on your mobile, the message contains one or more file attachments, you apply a label (say GoogleDrive) to that message and automatically all those attachments are saved to one of the folders on your Google Drive.

 

And since Google Drive will automatically synchronize with your desktop folders, the saved email attachments will instantly download and become available on your local disk as well for offline viewing."

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

Preview of new Google Apps Script libraries from simpleappssolutions.com

"We have been hard at work on a few new services and they are getting very close to launch.
The first two are Google Apps Script remixes from popular JavaScript libraries.

UnderscoreGS which gives you more than 30 great utilities like:
* _trim(str)
* _first(array, n, guard) - Get the first element of an array. Passing n will return the first N values in the array.
* _groupBy(obj, val) - Splits a collection into sets, grouped by the result of running each value through iterator.
* _contains(obj, target) - Returns true if the value is present in the list, using === to test equality.
* _find(obj, iterator, context) - Looks through each value in the list, returning the first one that passes a truth test
* And so much more.."

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

Approval Workflow using Apps Script - Google Apps Developer Blog

Approval Workflow using Apps Script - Google Apps Developer Blog | Google Apps Script | Scoop.it

"Recently a company who operates retail stores throughout a few states reached out to Dito. When their associates conduct business discussions with vendors or customers where monetary exchanges are involved, their Ethics Disclosure policy requires a log for each event, a supervisor approval, and committee review.


The customer’s existing disclosure review process was cumbersome and time consuming. The employees would add a disclosure review request to a spreadsheet with 29 columns. The new review request would then be reviewed by their supervisor. The supervisor and the employee would go back and forth exchanging emails and making changes to a dense spreadsheet until an approval was granted. It was clear that the customer needed a workflow solution. They decided to hire Dito to build a workflow solution based on Google Apps Script."

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

Introducing the Script Service - Google Apps Developer Blog

"Triggers in Apps Script allow you to schedule your script’s execution in response to an event, at a specific time and date, or at given time intervals. Publishing scripts as services allows you to deploy your web apps with a click of a button. The new Script service lets you perform both of these tasks programmatically. With the Script service at your disposal, you can create smooth install flows, chain your scripts’ executions, generate summaries of current triggers, and even programmatically publish the scripts as services."

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

Notes on extracting the JISC CETIS twitter follower network using Google Apps Script– MASHe

Notes on extracting the JISC CETIS twitter follower network using Google Apps Script– MASHe | Google Apps Script | Scoop.it

This post includes an extension to 'Export Twitter Followers and Friends using a Google Spreadsheet' which combines results in one sheet for easier analysis in tools including NodeXL and Gephi

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

Google Apps Experts: Advanced Google Sites Tip -- Create Announcements from Calendar Events

Using Google Apps Script to push Google Calendar events to Google Sites announcments 

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

A First Attempt at Apps Script with Spreadsheets - Google Apps Developer Blog

A First Attempt at Apps Script with Spreadsheets - Google Apps Developer Blog | Google Apps Script | Scoop.it

The Apps Script team held a hackathon in Washington DC on March 7. Over 80 developers attended and we had some great demos at the end of the evening. One of the demos was from Rusty Mellinger, who explains his script in this blog post. If you missed the DC hackathon, sign up for our next one in Chicago on April 19. -Jan Kleinert


"I was lucky enough to attend Google’s Apps Script Hackathon at their office in DC, recently, and got a chance to play with Apps Script. After a quick walk-through tutorial, Jan gave us a couple of hours to hack around with it."

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

Tutorial: Schedule AdSense reports with Google Apps Script - Google Apps Script — Google Developers

This tutorial shows how to use Google Apps Script to build an application that creates AdSense reports in chart form and emails them to designated recipients.

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

Using Google Spreadsheets to dashboard project/course blog feeds using Apps Script

Using Google Spreadsheets to dashboard project/course blog feeds using Apps Script | Google Apps Script | Scoop.it

In this post I’ll show I’ve create a quick dashboard in Google Spreadsheets which takes a list of blog RSS feeds and filters for specific tags/categories. The final result uses the Xml parse, UrlFetch and Cache services in Google Apps Script

more...
No comment yet.
Suggested by t.kenan
Scoop.it!

Dynamic FAQ Section w/ jQuery, YQL & Google Docs | Tutorialzine

Dynamic FAQ Section w/ jQuery, YQL & Google Docs | Tutorialzine | Google Apps Script | Scoop.it
In this tutorial, we are making a dynamic FAQ section. The script, with the help of jQuery & YQL, will pull the contents of a shared spreadsheet in your Google Docs account, and use the data to populate the FAQ section with content.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Code Walkthrough: Event Registration Template - Apps Script Hackathon Chicago

Code Walkthrough: Event Registration Template - Apps Script Hackathon Chicago | Google Apps Script | Scoop.it
"This tutorial will take you through the process of building a script that will manage event registration, including sending confirmation or waitlist emails to attendees, as well as sending reminder emails before the event."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Apps Script Dashboard and Quotas - Google Apps Developer Blog

Apps Script Dashboard and Quotas - Google Apps Developer Blog | Google Apps Script | Scoop.it

"Today, we are launching the Google Apps Script Dashboard. This experimental dashboard can be used to monitor the health of 10 major services. It also provides a detailed view into the quota restrictions in Apps Script."

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

Docs Blog: April in Review: New fonts galore and other fresh features (inc Apps Script)

"Apps Script had many improvements, including
* A new ScriptService for programmatically publishing your scripts and controlling when they run.
* A new function to find the root folder of someone’s Drive.
* An increase in the allowed attachment size in emails from 5MB to 25MB.
* An increase in the size of docs files you can create from 2MB to 50MB."

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

Google Apps Handout Generator

Problem of practice

Creating google templates, instructing students to share appropriately and then organizing all the shared files correctly can be a time-consuming task.

 

Solution

This is a simple script housed in a google sheet that allows teachers to create handouts for their classroom, shares the student appropriately and organizes the handouts in a collection. It can be used to create sheets as well as docs.

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

Google Offering Analytics for Your Email Inbox - Apps Script Featured on mashable.com

Google Offering Analytics for Your Email Inbox - Apps Script Featured on mashable.com | Google Apps Script | Scoop.it

"Called Gmail Meter, the program analyzes email patterns to give a better sense of overall inbox activity. Gmail Meter was developed by Romain Vialard, a Google Apps Script Top Contributor, so it wasn’t created by Google but the site supports it."

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

Crowd Sourcing with Google Forms, Fusion Tables and Apps Script - Google Apps Developer Blog

Crowd Sourcing with Google Forms, Fusion Tables and Apps Script - Google Apps Developer Blog | Google Apps Script | Scoop.it

"Finally, Apps Script acts as the glue between the Google Form and the Fusion Table, since there is currently no direct way to send Google Form submissions to a Fusion Table. During a hack event last year, I took some time to write an Apps Script script that submits the form data to Fusion Tables."

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

Docs Blog: March in Review: Improved charting, expanded language support, and Apps Script updates

Docs Blog: March in Review: Improved charting, expanded language support, and Apps Script updates | Google Apps Script | Scoop.it

More ways to use Google Apps Script
Google Apps Script is a way for developers to customize Google Docs and other Google products. Over the past month, we’ve made some changes which developers may find helpful, including:

 

* Support for adding your own HTML to your script’s dialogues and pages. Let’s say you wrote a script that prompts collaborators to play a game when they open a certain spreadsheet. It’s now possible to include more sophisticated HTML, like a table in the dialog that you built.

 

* The option to programmatically set sheet protection in Apps Script. If you’re a teacher, you could add a script that automatically looked at all your spreadsheets and made sure that you’re the only one allowed to edit any sheet named “Grades”.

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

How to make charts in Google Apps Script - Excel, VBA, javaScript and Google

How to make charts in Google Apps Script - Excel, VBA, javaScript and Google | Google Apps Script | Scoop.it

"Google Apps Script offers a charts service. Using this you can build a dataTable as input to a chart, as well as the chart itself. Elsewhere on this site I covered how to get Excel data into Google Visualization Charts, and how to create Google Data Tables in such projects as Using Google Visualization charts and tables, Using Google Visualization DataViews, Embedding Google Motion Charts in Excel and various other articles. Now it turns out that Google Apps Script has something like these capabilities, but rather less feature rich versions. As in What to use in place of Excel Shapes we use a UI panel to contain the chart object. The Excel versions of How to use the Excel Roadmapper shows how to create a 'cost of ownership chart' appended to a roadmap, and looks like this."

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

Google Script Color Ramp - Excel, VBA, javaScript and Google

Google Script Color Ramp - Excel, VBA, javaScript and Google | Google Apps Script | Scoop.it

"For those of you that have been following VBA to Google Apps Script, here is another one. This time, it's a conversion of the Excel color ramp library."

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

JDBC Overview - Google Apps Script — Google Developers

JDBC Overview

Google Apps Script has added the ability to make connections to databases via JDBC. The current support extends to MySQL, Micorsoft SQL Server and Oracle.

more...
No comment yet.