"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."
"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."
"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."
Creating google templates, instructing students to share appropriately and then organizing all the shared files correctly can be a time-consuming task.
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.
"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."
"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 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”.
"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."
"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.
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.
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.
"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."
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."
"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."
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.."
"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."
"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."
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."