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

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

From VBA to Google apps script - a comparison using a real project

"A few weeks ago I wrote about starting my effort to convert a complex VBA project to Google Apps Script. I vaguely remember thinking at the time that this was going to be a pretty straightforward activity. Just emulate a few VBA functions and do a little tweaking.

 

 

I was wrong. The reality has been a little different, as along the way I've had to figure out a bunch of stuff including the best approach to classes, work through some GAS gotchas , emulate a VBA collection in javaScript, create some timers to figure out why GAS is so slow, and create a caching mechanism to make it acceptable, figure out what shapes to use instead of Excel Shapes, and figure out how to add Charts to the final roadmap"

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

Merge info from Google Forms to PDF Document and Send via Email using Apps Script

Merge info from Google Forms to PDF Document and Send via Email using Apps Script | Google Apps Script | Scoop.it

Today we needed a way to easily take information submitted from Google Form and create a form letter so administrators can sign and send it home with a student. I went through several mail merge scripts but nothing fit exactly what I needed so I took some of the best ideas from all of them (especially the employee of the month script) and created a system that works for us. This method of utilizing Google Apps script can be used for certificates for PD sessions, creating awards, or any other documents in which you need to get information that is submitted via a Google form.

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

Google Apps Script access to Spreadsheets - up to 100 times faster by @brucemcpherson

In a previous post, I introduced the concept of local caching of Google Docs Spreadsheet Values to be able to optimize Google Apps Script without needing to change the structure of your code. This gave us speed increases about a factor 70 versus accessing values one by one.

 

Noticing that there are other Range methods, such as getBackgroundColors(), getComments() etc, all of which are really slow too, I wondered if they could also be cached. Of course they can, and with actually pretty minimal effort, I generalized the caching class to handle any method that can return a 'Range shaped' set of values or objects.

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!

Google Apps Experts:Google+ Profile Cards in Google Sites using Apps Script

Google Apps Experts:Google+ Profile Cards in Google Sites using Apps Script | Google Apps Script | Scoop.it

"A Google Apps Script to pull Google+ profiles from your contacts and list Google+ Profile Cards on a Google site web page."

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

Geocoding Postal Addresses with Google Maps API | The Programmer's Library

Let’s say you have a bunch of postal address in a spreadsheet and you wish to geocode these addresses (get the latitude and longitude information).

 

While there are several web apps available that that can geocode addresses, one of the easier options is available inside Google Apps Script.

 

Just past the list of postal address in a column in Google Docs spreadsheet and then run the following Google Apps Script to transform them into latitudes and longitudes.

more...
No comment yet.