Google Apps Script
Follow
Find
62.5K views | +27 today
 
Scooped by Martin Hawksey
onto Google Apps Script
Scoop.it!

Delegation to Google Apps Script - Excel Liberation by Bruce McPherson

Delegation to Google Apps Script - Excel Liberation by Bruce McPherson | Google Apps Script | Scoop.it
" In a number of articles I've covered how to use GAS for jsonp, oauth, as a lockbox and various other useful things. There are many threads to pull together in this section, so here's a step by guide to GAS proxying as described in this post."
more...
No comment yet.

From around the web

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!

Dynamically remove Google Form options after they have been selected by someone or reach defined limits

Dynamically remove Google Form options after they have been selected by someone or reach defined limits | Google Apps Script | Scoop.it

You can imagine the scenario, you’ve got a Google Form perhaps setup as a booking form and a select option for picking timeslots. As the slots fill up you’d like the option to be removed. I was surprised not to find an example of this so here is a rough sketch of some code that might do the job.

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

Allow anyone to add videos to a YouTube playlist from a Google Form using Google Apps Script

Allow anyone to add videos to a YouTube playlist from a Google Form using Google Apps Script | Google Apps Script | Scoop.it
A quick example of how you can use Google Apps Script to automatically allow anyone to add YouTube videos to one of your playlists
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Synergyse Blog: Google Apps Script: Tips for the first-time developer

Synergyse Blog: Google Apps Script: Tips for the first-time developer | Google Apps Script | Scoop.it

"If you are new to Google Apps script this post will give you the information you need to get started.  Writing a Google Apps Script can be an intimidating process for those who have not done programming before so be patient and take your time getting comfortable with this incredible tool for educators."

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

Synergyse Blog: Top 5 ways to use autoCrat in education [How-To]

Synergyse Blog: Top 5 ways to use autoCrat in education [How-To] | Google Apps Script | Scoop.it

"Created by educators working in the CloudLab, a project of the non-profit New Visions for Public Schools, autoCrat is an add-on that allows you to merge data from your Google Sheets into a custom Google Doc template built and designed by you.  This add-on can be especially powerful when combined with Google Forms.  Upon submission of the form, autoCrat can be configured to automatically email the merged information in the form of a PDF or Google Doc to an email address collected within the form or designated in the autoCrat set up process.  

Why would educators want to use autoCrat?  Here are my top 5 favorite ways that educators are utilizing this Add-on"
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

8 Surprisingly Useful Things You Can Do With Google Sheets and Google Apps Script

8 Surprisingly Useful Things You Can Do With Google Sheets and Google Apps Script | Google Apps Script | Scoop.it
Google Apps Script is a surprisingly powerful scripting language often implemented using Google Sheets. It allows people to develop lightweight web applications, and those scripts run in the cloud on Google’s servers.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

chromebookInventory Google Sheets add-on - export/update your Chromebook inventory via a Google Sheet

chromebookInventory Google Sheets add-on - export/update your  Chromebook inventory via a Google Sheet | Google Apps Script | Scoop.it
chromebookInventory enables download and update of the metadata and Org Units of enrolled Chrome devices direct from a Google Sheet.
Martin Hawksey's insight:

via @mccarthy1688

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

Extensions, Add-Ons and Apps, Oh My! How to Utilize Google in Your Classroom - EdSurge

Extensions, Add-Ons and Apps, Oh My! How to Utilize Google in Your Classroom - EdSurge | Google Apps Script | Scoop.it
Google Apps for Education has totally transformed the way we teach and communicate inside and outside of the classroom.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Parallel process orchestration with HtmlService in Google Apps Script - Desktop Liberation

Parallel process orchestration with HtmlService in Google Apps Script - Desktop Liberation | Google Apps Script | Scoop.it

"Here's a framework for automating parallel processing with Google Apps Script. You can do Map/reduce operations, beat the 6 minute limit, and simulate multiuser activity and watch progress in real time. "

more...
No comment yet.
Suggested by Shunmugha Sundaram
Scoop.it!

How To: Get Email Notifications When Any Google Document is Updated

How To: Get Email Notifications When Any Google Document is Updated | Google Apps Script | Scoop.it
Learn how to get automatic email notifications when any shared Google document has been updated or edited by someone.
more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Do something in 5 with gas 4- Get your analytics profiles to a spread…

Another in the 'do something useful with Google Apps Script' series. This time you'll see how to use the Analytics service and use exponential backoff to mitig…

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

TwtrService Example: EasyTweetSheet (lets you send tweets from Google Sheet)

TwtrService Example: EasyTweetSheet (lets you send tweets from Google Sheet) | Google Apps Script | Scoop.it
Very basic Google Sheet template to let you draft tweets which are published to Twitter when you click a link.
Martin Hawksey's insight:

Following the publication of TwtrService (Google Apps Script client library for Twitter) here's a basic Google Sheet template we use at +ALT to draft tweets we send during events (instead of just sending them on a schedule we have to control to click a link to send)

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

Do something in 5 with gas 3-simple invoicing app

quick 5 minute tutorial. join multiple databases and create personalized email invoices with google apps script

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

Big Data, Small Insights | LinkedIn

Big Data, Small Insights | LinkedIn | Google Apps Script | Scoop.it

"The integration to Virtual PBX is a custom gateway designed to harvest PBX call data logs and filter them based on calls associated with reservations extensions. I used Google Apps Script to automate the update of call data in near-real-time despite the fact that a formal API is not available from this PBX provider.


The data is stored into a 13 column spreadsheet capable of handling approximately 25,000 calls per month with a ceiling of about two years worth of data. All processes and integration with Virtual PBX is handled by Google Apps Scripts (GAS) and available as an installable service"

Martin Hawksey's insight:
Bill French, Founder and Editor at iPadCTO outlines how they use Google Apps Script for custom data collection and reporting
more...
brucemcpherson's curator insight, November 27, 12:41 PM

great mash up of GAS & Analytics and other stuff.

Scooped by Martin Hawksey
Scoop.it!

Create a Tree View of your Google Drive

Create a Tree View of your Google Drive | Google Apps Script | Scoop.it
Learn how to create a hierarchical tree listing all the files and folders in your Google Drive. The Drive tree can also be printed or saved for later.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

New Google Add-on: Pupil Pref for Google Documents

New Google Add-on: Pupil Pref for Google Documents | Google Apps Script | Scoop.it

"A simple add-on to change the background colour and reduce visual stress."

Martin Hawksey's insight:

Great to see accessibility being enhanced in Google Documents with this add-on

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

Google Apps Script: The authentic{ated} playground (3 things that make Apps Script rock) #DevFest

Google Apps Script: The authentic{ated} playground (3 things that make Apps Script rock) #DevFest | Google Apps Script | Scoop.it
I was recently invited to London to talk at the GDG DevFest London. As part of the 'authenticated playground' I highlighted 3 core features of Google Apps Script
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Math Tech Tips: New Script that will create Google Forms from questions in a Spreadsheet

Math Tech Tips: New Script that will create Google Forms from questions in a Spreadsheet | Google Apps Script | Scoop.it
" There was a query posted in the GEG Singapore about automatically creating forms from spreadsheet questions. g(Math) kind of does this, so I threw a script together that will create a form from a highlighted range. It will even create multiple choice questions from option in the sheet (I am especially proud of that aspect). Check it out here and make a copy to play around"
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Some hints on setting up parallel running profiles (in Google Apps Script) - Desktop Liberation

Some hints on setting up parallel running profiles (in Google Apps Script) - Desktop Liberation | Google Apps Script | Scoop.it
"The other day I showed how to run Apps Script tasks at once using HTMLService to orchestrate the results. This not only gets stuff done quicker but avoids having to worry so much about running out of quota, since parallel tasks each have their own quota. In this example I'm running some cryptography tasks in parallel that wouldn't normally be able to finish. This tutorial includes all the code you'll need to do the same thing."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Allow anonymous uploads to a specific folder in Google Drive

"I've had a heck of a time trying to figure how to allow anonymous uploads to a specific folder in Google Drive. Places where this might be useful would be resume submissions for employment or other applications where users might not have a Google Account. In my district, I'm using it to collect submitted WDE reports from administrators for archival purposes.

After some initial confusion, I was able to hack my way through a Google Apps script that works to allow uploads to a specific folder in Google Drive. Couldn't come at a better time as our Google Drive finally went unlimited." +Cole Nicholas 

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

Getting Started with Google Apps Script

This is a live broadcast of a session of Apps Edu Certified Trainers discussing and sharing resources about Google Apps Script. Focus will be on understandin...
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

A new tab in GAS project properties Scopes

A new tab in GAS project properties Scopes | Google Apps Script | Scoop.it
A new tab in GAS project properties Scopes
Martin Hawksey's insight:

Via +Ivan Kutil

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

Time-consuming tasks and Google Apps Script Add-ons - Google Apps Script Examples

Time-consuming tasks and Google Apps Script Add-ons - Google Apps Script Examples | Google Apps Script | Scoop.it
"It is very easy to overcome that limit, simply by going back and forth between the server and the client side in your add-on. ...."
more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Do something useful in Apps Script 5. Get your analytics pageviews to…

Here's how to build on previous tutorials to get your Google Analytics PageView data into a Spreadsheet.

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

Orange Coding: GmailSearchBuilder - A Google Apps Script Library

Orange Coding: GmailSearchBuilder - A Google Apps Script Library | Google Apps Script | Scoop.it
A Google Apps Script service for building Gmail search queries
more...
No comment yet.