Google Apps Script

By Barrie Roberts | GAS and Javascript related to GAS

Apps Script – First Docs and Forms Scripts

Following on from my last post on creating your first script, here we’re going to edit a Google Doc and also a Google Form. This will show you how …

Apps Script – Creating & sharing Class folders in Drive

Teachers using Drive often need to set up folders for their class and for their individual students. Doing it in Drive is not the most exciting job …

Education Technology

Apps Script Basics – First Script

Here I want to show you how easy it is to write some code using Apps Script. This is the code that sits in the background of some of the Google Apps. …

Programming

Apps Script – Clocking in & out system

In this post, we’ll look at setting up a simple clocking in and out system using Google Forms and Sheets. This idea originally came from a real life …

PHP

Multiple FOLDER maker

Making multiple copies of folders in Google Drive is a slow, boring task. You select the folder you want, make a copy, then have to rename it, then …

Google Drive

Multiple FILE Maker

Making multiple copies in Google Drive is a slow, boring task. You select the file you want, make a copy, then have to rename it, then repeat this …

Google Drive

Pimp up your Sheet – Programmatically!

When working with spreadsheets we can spend quite a long time making them look good and if we have to make the same sheets over again, that’s a lot …

Book inventory

Here we’re going to make a simple book inventory, where we’ll be able to control the location of the books and also find out where a book is. This …

Automatically emailing info from a form submission

Here we’ll look at how to set up automatic emails, which contain information submitted by the Google Form user. The beauty of this is that the …

Google Apps Script doGet and doPost Tutorial + 6 Web App Examples

Trevor Fox<p>January 30, 2017<p>If you are new to Google Apps Script or programming in general, Google Apps Script Web Apps may seem daunting. The good …

Request form – Sending automatic emails

One of the most useful things I’ve learnt to do with Google Apps Script, is to email people automatically when a form is submitted. It has countless …

19 Useful Google Apps Scripts to Automate Google Drive

Google Drive offers great features for storing and working with different types of files but it does lack at some features that are crucial for your …

Google Drive

App Maker University

2016 - Another year in Apps Script

The real world of 2016 has been full of madness, badness and sadness. It's impossible to reflect on its events without thinking of the divisiveness, …

Totally Unscripted: Episode 6 - Analytics in Add-ons and App Maker

Google Apps Script: Create Your Own Mail Merge - Teacher Tech

I use peer evaluation quite a bit in my class. My data is collected via a Google Form and are in a spreadsheet. I use mail merge to send students …

Education Technology

Creating a Google form that will automatically email users a copy of the form - SBS Technology Enhanced Learning

We were asked to find a way to send an auto reply email to users who had completed an online form. An email also needed to be sent to their line …

Google Spreadsheets as a Database – INSERT with Apps Script form POST/GET submit method

Update 04/07/2014: I’ve revisited this code and made a number of improvements. Read more in Google Sheets as a Database – INSERT with Apps Script …

Google Apps Script: Create New Tabs - Teacher Tech

Create Tabs in Google Sheets<p>Google Apps Script allows you to customize what Google text docs and Google Sheets can do for you. It is based on …

Create Auto responding google form with 2 lines of code

One of the most requested features in google forms is auto-respond but still it is not built in with google form. But we can add this feature with …

PHP

Automate Google Sheets: An Introduction to Google Apps Script - The Ultimate Guide to Google Sheets

Google has built some of the most effective productivity tools on the planet. With Gmail, Hangouts, Chrome, Docs, Sheets, and more, odds are you use …

Google Drive

Html Service Basics - Write Form Data To A Spreadsheet

<b>Update 14-Sep-2015: See chapter 7 in leanpub book This chapter has been fully re-written and expanded</b><br>As stated in the previous post, GUI Builder is …

How to make programmatic Google Forms

16 Jul 2015<p>Let’s pretend you’re making a survey. And you want to ask the same thing many times, with only the slightest modification.<p>What if you want …

Is it possible to 'prefill' a google form using data from a google spreadsheet?

I'm looking for a way to 'pre fill' a google form with specific data from a google spreadsheet. The form will have the same 'standard' questions for …

Google

Supercharge your Google Form with Google Apps Script!

I love Google Docs, and with just a little bit of JavaScript, you can supercharge any of your Google Docs using Google Apps Script. In this blog, …

How to Copy an Entire Folder to Another Folder in Google Drive

Google Drive, launched almost 4 years ago, is an online vault where you can store all your files and documents. It offers nearly all the …

Google Drive

Google Slides – Master slides and themes

The built-in themes provide a great springboard to make professional looking slides but what happens if you want them to look different? Or what …

Count cells based on color in the new google sheets?

When using a custom function like the one above, you have to make sure the range is passed to the function and not the values. That's why you have to …

Create Google Calendar Events from Spreadsheet but prevent duplicates

I'm trying to write a script that will take data from a Google spreadsheet and create events in my Google calendar.<p>I managed that fine but it …