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

Keep your Twitter Archive fresh on Google Drive using a bit of Google Apps Script

Keep your Twitter Archive fresh on Google Drive using a bit of Google Apps Script | Google Apps Script | Scoop.it
Looking for a way to keep my Looking for a way to keep my Twitter Archive fresh I stumbled on this method for reading/writting/hosting files on Google Drive using Google Apps Script
more...
No comment yet.
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!

Google Apps Script locking and optimum wait times and the golden ratio

Google Apps Script locking and optimum wait times and the golden ratio | Google Apps Script | Scoop.it

"You are probably familiar with the Google Apps Script Lock Service, which is a way of preventing concurrent access to sections of code. It works well, but the problem is that it's a fairly blunt instrument.


Let's say that you want to use the same code to deal with multiple resources - say a spreadsheet tab. With lock service you'd  lock  all spreadsheet tabs that were accessed by that code.  This is especially a problem if you are using shared libraries which may be accessed by many people accessing many resources."

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

Flattening and unflattening objects to spreadsheets with Google Apps Script - Desktop Liberation

"In Flattening an object with dot syntax I showed how to take a an object of more than 1 level deep and flatten it so it could be represented in a two dimensional object like a spreadsheet. Now here's the opposite, unflattening an object created that way. I also provide a library you can use for flattening and unflattening, as well as processing objects to and from spreadsheets"

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

ScriptDB Going Read-Only Tomorrow - Eric Koleda – Google+

ScriptDB Going Read-Only Tomorrow - Eric Koleda – Google+ | Google Apps Script | Scoop.it

"ScriptDB was officially shut down on November 20th, but we decided to wait until after Thanksgiving to pull the plug. We're going to start by making the service read-only tomorrow, perhaps for a couple of hours to start but eventually permanently. This should help ferret out any places you are still using the service and give you time to export your data" - Eric Koleda – Google+

Martin Hawksey's insight:

For an alternative flow worth checking out @brucemcpherson's DbAbstraction http://ramblings.mcpher.com/Home/excelquirks/dbabstraction

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

+David Bingham: Apps Script Gmail Utilities (including sending mails from draft)

"Using the GMail service provided by Google Apps Script you can script many GMail capabilities. One thing you cannot do is directly send existing draft messages.

 

This script contains a few utilities (maybe the foundation of a library, someday) that deal with draft emails, including using the GMail API to retrieve and send draft messages.

 

No more need to resort to generating a whole new copy of a draft, send the copy, delete the draft... instead:"

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

AppsScript Color: Chrome extension to change the color style of the google apps script editor

AppsScript Color: Chrome extension to change the color style of the google apps script editor | Google Apps Script | Scoop.it
This extension change the color style of the google apps script editor
Martin Hawksey's insight:

via +Romain Vialard 

 

https://plus.google.com/+RomainVialard-public/posts/Duqkva519xq

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!

Speeding up HtmlService in Apps Script - Google Apps Developer Blog

Speeding up HtmlService in Apps Script - Google Apps Developer Blog | Google Apps Script | Scoop.it

"Apps Script's HTML service is a great way to easily build user interfaces for Docs, Sheets, and Forms add-ons. However, HTML service is S-L-O-W. And until today there have been quite a few restrictions on using HTML service, including the inability to use a variety of JavaScript libraries.

Today, we are introducing an update to HTML service — IFRAME sandbox mode. Using this sandbox mode, you can significantly improve the performance. There are three key benefits.

 

1. Your UI loads up much faster

2. Standard HTML, JavaScript, and CSS features are now available without any restrictions.

3. It requires very few code changes: just set the SandboxMode to IFRAME:

Martin Hawksey's insight:

Post also notes UI and DocsList service is deprecated.

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

Hour of code: Google Apps Script Educators

Bjorn Behrendt and Charlie MacFayden, Vermont Educators share how they use Google Apps Script in teaching and learning. 
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Parallel Processing GmailApp.search() in Google Apps Script - Jacob Jan Tuinstra

Parallel Processing GmailApp.search() in Google Apps Script - Jacob Jan Tuinstra | Google Apps Script | Scoop.it

"For a few of my answers on Web Applications, I’m constantly busy finding a solution to retrieve all information via the GmailApp.search() method. As explained in the text, this method is only usable for small amounts of threads. If you query a label containing 1000 emails for example, you will only get 500 items back. 


In the meantime, Bruce McPherson, was hitting the road with his awesome posts, starting with the Running things in parallel using HTML service. ... made me think of a way to incorporate some sort of while loop. Basically, I'm re-starting the script to continue working on retrieving the information untill all information is fetched. Read below to find out how I did that""

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

Simulating multiuser testing in Google App Script - Desktop Liberation

Simulating multiuser testing in Google App Script - Desktop Liberation | Google Apps Script | Scoop.it

"When developing Database abstraction with google apps script I had real trouble simulating multiuser interactions, especially when there wasn't a real database behind (like sheets and drive). I had a mechanism in Using named locks with Google Apps Scripts to be able to lock from updating, but it was really hard to get a good multiuser test going. 


Using this parallel running mechanism is of course perfect - since it executes as many threads as I want in parallel with each other. If I get then all to hit the same back end at once, then I have a pretty intensive multi user test. "

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

Function to convert an XML string to a JSON object in Apps Script

A function to convert an XML string to a JSON object in Apps Script, using logic similar to the sunset method Xml.parse(). - Gist is a simple way to share snippets of text and code with others.
more...
No comment yet.
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.