Google Apps Script
Follow
Find
54.3K views | +54 today
Suggested by wterral
onto Google Apps Script
Scoop.it!

Teacher Mini-Observation Tracking System using Google Forms and Google Apps Scripts by Andrew Stillman

Teacher Mini-Observation Tracking System using Google Forms and Google Apps Scripts by Andrew Stillman | Google Apps Script | Scoop.it

Problem

"How can overburdened school administrators manage their workflow to enable short mini-observations aligned to a teacher effectiveness framework like Danielson without getting locked into expensive, proprietary software?"

 

Solution

"This well thought-out template, created by a collaboration between a highly successful NYCDOE principal and an Apps Script developer, makes data entry a snap, helps administrators prioritize observations, and supports communications with teachers."

 

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 Educast #151: Google Apps Script Guru, Andrew Stillman - EdReach

Google Educast #151: Google Apps Script Guru, Andrew Stillman - EdReach | Google Apps Script | Scoop.it
"Our special guest for the show is none other than EdTech royalty, Andrew Stillman, creator of insanely useful scripts and Add-ons … most notably, Doctopus and Autocrat. Andrew talks about some of the tools you might not have heard of like siteMaestro and chromebookInventory. He also chimes in on his unique perspective on Google Classrooms."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Using Google Apps Script to proxy YouTube Analytics Channel Reports

Using Google Apps Script to proxy YouTube Analytics Channel Reports | Google Apps Script | Scoop.it

YouTube Analytics Channel Reports are restricted to the user authorizing the request must be the owner of the channel. This can cause issues in Apps Script when interacting with other services. This post highlights a workaround where the data is proxied via a separate script published as a web app.

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

Automatically updating a Google Sheet with data from Google Analytics for regular reporting

Automatically updating a Google Sheet with data from Google Analytics for regular reporting | Google Apps Script | Scoop.it

There are regular reporting features built in to Google Analytics but what if you want to do customised reporting? One answer is Google Apps Script and this post walks you through access Google Analytics data in one line of code and setting up automated collection

more...
Moneback Rusty's curator insight, July 22, 6:23 AM

Regarder film en streaming 
Film Porno en streaming 
streaming 
Film Porno 
Film en streaming 
Film streaming Vf 
Film X en streaming 
Film en streaming Gratuit 
Film X 
vk streaming 
film 
Films en streaming Gratuit

Films en streaming VF | Regarder film complet en streaming gratuit


Mots clés en Associées à: Film en streaming 
Film en streaming 
Regarder film en streaming 
Film Porno en streaming 
streaming 
Film streaming Vf 
Film X en streaming 
Film en streaming Gratuit 
Film X
Lieu de tournage streaming 
Film streaming Verser mobile Gratuit 
Film streaming Payant 
Film en streaming pour téléphone portable 
Abonnement Film en streaming 
Regarder Film X en streaming Gratuit 
Film streaming Xxl Gratuit 
Film en streaming pour portable

Film Streaming Gratuit en francais Films en streaming VF | Regarder film complet en streaming gratuit

Moneback Rusty's curator insight, July 22, 6:30 AM

Film en streaming Gratuit 
https://www.facebook.com/filmstreamsgratuits

 

Regarder film en streaming 

 

https://www.facebook.com/streaming.films7

 


Film X en streaming
Film en Streaming Gratuit
Regarder film en streaming Gratuit
Film en streaming Vk
Film en streaming
Film en streaming Vf
Film Porno en Streaming
Regarder Un Film en streaming
Voir Film en streaming
Film Erotique En streaming
Série en streaming
http://filmstreaminggratuit.net/

 

Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Datastore driver - Desktop Liberation

Datastore driver - Desktop Liberation | Google Apps Script | Scoop.it

the Google Cloud Datastore driver for Google Apps Script database abstraction.


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

How to poll a Google Doc from an add-on

How to poll a Google Doc from an add-on | Google Apps Script | Scoop.it
A documented restriction with document and sheet add-ons is that Apps Script cannot tell what a user does outside of the add-on. This tantalizing tip is given: It is possible to poll for change...
more...
No comment yet.
Rescooped by Martin Hawksey from iGeneration - 21st Century Education
Scoop.it!

Super Quiz on Google Forms - Full Guide - YouTube

Super Quiz Full Guide

Via Tom D'Amico (@TDOttawa)
more...
Jerry Johnson's curator insight, July 9, 4:57 AM

Very nice! 

Alfonso Gonzalez's curator insight, July 10, 3:00 PM

It's like Flubaroo with a few more features of automaticity.

Scooped by Martin Hawksey
Scoop.it!

Data wrangling with named columns in Google Spreadsheet with Apps Script - Desktop Liberation

"In Using crossfilter with Google Apps Script I showed how to use the powerful crossfilter library to do some data wrangling. But using some of JavaScript's Advanced Array functions, and working with named columns instead of column numbers gives you a lot of wrangling power straight out of the box. "
Martin Hawksey's insight:

Not forgetting you can do some sophisticated data manipulation with built-in Sheet formula like QUERY, SORT and combining others using ARRAYFORMULA 

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

Google Sheets as a Database - INSERT with Apps Script using POST/GET methods (with ajax example)

Back in 2011 I showed how you can use Google Apps Script to write POST/GET data to a Google Sheet. Over the years a couple of things have changed in Apps Script so I thought it was worth a revisit. This version uses features like LockService, PropertiesService and ContentService to make it more robust and make it possible to do ajax powered form submissions. The post includes a couple of tips that appear to be catching people out including versioning and permissions scope. 

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

Breakpoints and the Apps Script Debugger | Drive Bunny

Breakpoints and the Apps Script Debugger | Drive Bunny | Google Apps Script | Scoop.it
" Using the debugger, you can set break points in the code at places of your choice. When code execution lands on a break point, it halts; while time remains frozen, you can check how your code is operating, examine variable values, read log messages etcetera."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Using Content Assist in Google Apps Script | Drive Bunny

Using Content Assist in Google Apps Script | Drive Bunny | Google Apps Script | Scoop.it

"I always have difficulty remembering the exact syntax of some programming constructs, such as the order of parameters in a function call, or the exact name of a method.


I’ve often abandoned the blinking cursor within the Code Editor to go and look for reference material, either online or printed.

 

Luckily, Google’s Code Editor has something called Content assist to come to the rescue"

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

How to Sell Digital Products Online with Google Drive and PayPal

How to Sell Digital Products Online with Google Drive and PayPal | Google Apps Script | Scoop.it
The guide explains how you can quickly and easily sell digital products like PDF ebooks, music, website themes, etc. through Google Drive, PayPal and Gmail.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Connecting to MySQL Databases using Apps Script | Drive Bunny

Connecting to MySQL Databases using Apps Script | Drive Bunny | Google Apps Script | Scoop.it
" Being able to write to, and read from, [mySQL] databases directly from your Google Sheet can be a huge advantage. In the e-commerce example, for instance, you may want todownload order information for delivery completion, label printing or later sales analysis, or you may choose to upload new data from your spreadsheet to the on-line store including prices, product descriptions and so forth."
more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

EzyOauth2 - taking some pain out of Apps Script API authentication

EzyOauth2 - taking some pain out of Apps Script API authentication | Google Apps Script | Scoop.it

brucemcpherson's insight:

"If you are writing Apps Script webapps and accessing some of the Google JSON APIs services, you're going to need to deal with oAuth2. This library using the statetokenbuilder should help get it right first time." 


Via brucemcpherson
more...
brucemcpherson's curator insight, June 11, 11:01 AM
If you are writing Apps Script webapps and accessing some of the Google JSON APIs services, you're going to need to deal with oAuth2. This library using the statetokenbuilder should help get it right first time.  
Scooped by Martin Hawksey
Scoop.it!

Send a Google Doc in an email message using Apps Script

Gist from Eric Koleda which fetches a Google Doc as HTML and then uses MailChimp API to convert CSS to inline to send in an email
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Mindset Blog: Tips for Creating a Google Apps Script/SAP Mashup

" We recently submitted our product CloudShuttle to the Chrome web store for Google Sheets add-ons.  Am I tired?  Yes.  Did I spend a few too many late nights in front of a code editor?  Yes.  

 

Would I do it again?  One hundred bajillion percent yes.

 

So, having spent the last few month with my head way inside the process to integrate Google docs with an SAP backend through NetWeaver Gateway, I humbly offer a few tips to the blogosphere for anyone wanting to do the same thing.  "

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

Relative performance - Desktop Liberation

Relative performance - Desktop Liberation | Google Apps Script | Scoop.it
In Migrate data from scriptDb to Datastore I showed how to copy over data easily from scriptdb to datastore. The good thing about abstracting the database is that code is the same regardless of which database use you are using (once you've got the handle). 
 
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Manage Chromebooks through a Google Sheet > chromebookInventory (Add-on) - New Visions CloudLab

Manage Chromebooks through a Google Sheet > chromebookInventory (Add-on) - New Visions CloudLab | Google Apps Script | Scoop.it

"This tool allows you to export and bulk update the key metadata and org units of your managed Chrome devices via a Google Sheet. "

more...
No comment yet.
Rescooped by Martin Hawksey from iGeneration - 21st Century Education
Scoop.it!

Super Quiz - Google Sheets add-on

Super Quiz - Google Sheets add-on | Google Apps Script | Scoop.it
Super Quiz adds brilliant functionality and assessment tools to a quiz made with Google Forms.

Via Tom D'Amico (@TDOttawa)
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Scripts/Extensions/Add-ons for Education

Google Apps Scripts/Extensions/Add-ons for Education | Google Apps Script | Scoop.it
Pins about Google Apps Scripts/Extensions/Add-ons for Education hand-picked by Pinner Stacy Olson | See more about google drive, extensions and scripts.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Multiple oAuth2 authentication packages (inc Google Datastore and Soundcloud)- Desktop Liberation

Multiple oAuth2 authentication packages (inc Google Datastore and Soundcloud)- Desktop Liberation | Google Apps Script | Scoop.it

"In EzyOauth2 - taking some pain out of Apps Script API authentication, I provided a library to simplify oAuth2, then in EzyOauth2 patterns I showed simple patterns for creating apps. Now you will probably want to have multiple authentication packages for different packages and scopes. Unfortunately, everybody's oAuth2 implementation is a little different, but we can still use  a standard pattern to abstract away those differences. 


To illustrate, I'm going to add a new oAuth2 package - this time for the soundcloud service. "

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

Parallel processing in Apps Script - Desktop Liberation

Parallel processing in Apps Script - Desktop Liberation | Google Apps Script | Scoop.it
" There's no getting away from the fact  that Apps Script is slower than the equivalent client based JavaScript processing. It is fundamentally synchronous in implementation, and also has limits on processing time and a host of other quotas. For a cloud based, free service that's about extending Drive capabilities rather than being scalable in the manner of Google App Engine, I suppose it's normal. But let's see if we can at least subvert at least these two things: * get over the 6 minute maximum execution time for Apps Script *run things in parallel "
Martin Hawksey's insight:
More magic from Bruce Mcpherson
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Some Simple Debugging for Google Apps Script

Some Simple Debugging for Google Apps Script | Google Apps Script | Scoop.it
" In this post I’ll cover some basic techniques that can help you track down and stomp on errors in your Apps Scripts."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Collaborative Tools Project: Gmail Scheduled Send Email

Collaborative Tools Project: Gmail Scheduled Send Email | Google Apps Script | Scoop.it

"Someone recently asked for the ability to schedule send an email. It was for a link to a class feedback form and ideally they'd like to be able to send it near the end of the class.

We looked at Boomerang, which had issues with authenticating with the York domain, and broke the CSS of Gmail slightly. We tried mx Hero, a Chrome app but after a tip off from a colleague and reading the reviews and discovering it at times didn't send the email, or used http rather than https etc we thought it might be better to look into making our own solution.

Apps Script to the rescue!"

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

Deprecating Script Gallery in the old version of Google Sheets - Google Apps Developer Blog

"Starting today, we are deprecating the option for developers to publish to the script gallery. No new gallery submissions will be accepted or approved, but scripts already present in the gallery will remain accessible (via the old version of Sheets). "

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

Save your Google Voicemail to Google Drive as MP3 Files with Google Apps Script

Save your Google Voicemail to Google Drive as MP3 Files with Google Apps Script | Google Apps Script | Scoop.it
The app will automatically save all your Google Voice voicemail messages in Gmail to your Google Drive as MP3 files along with the transcript.
more...
No comment yet.