Google Apps Script

By Barrie Roberts | GAS and Javascript related to GAS

Apps Script Basics (8) – Spreadsheet Class

In the my last post, we looked at the SpreadsheetApp class. Now, let’s look at the next group related to spreadsheets, which is the Spreadsheet …

Python Programming

Apps Script Basics – SpreadsheetApp & for in loop

In this post, we’re going to look at the G Suite services, the Google documentation that’s available to help you, and then focus on one particular …

Python Programming

Apps Script Basics – if, prompt, menu, & onOpen trigger

In this post, we’re going to look at how we can get the computer to react to data in a spreadsheet and to user input. We’re going to look at the …

Python Programming

Using fetch() and reduce() to grab and format data from an external API - A practical guide

Today we’re going to learn how to get and manipulate data from an external API. We’ll use a practical example from one of my current projects that …

JavaScript

Create quizzes in Google Forms with Apps Script

article<p>en_US<p>https://gsuite-developers.googleblog.com/2017/04/create-quizzes-in-google-forms-with.html<p>G Suite Developers …

Google Apps

Make & Send Kids Reports

In this post, we’re going to look how we can create kids reports from a Google Sheet and convert them into individual PDFs made from Google Docs, …

Google Apps

Apps Script Basics – Arrays, Logger, Execution Transcript

In this post, we’re going to look at another key area in Apps Script and indeed many coding languages, that of arrays, which are just special …

JavaScript: Learn Regular Expressions for Beginners

<b>In JavaScript, a regular expression is simply a type of object that is used to match character combinations in strings.</b><p>Make your first Regular …

Programming

Apps Script – Issues reporting form, log & email

In this post, we’ll look at a way to create a quick and simple system to report maintenance and IT issues in the classroom.<p>The teacher fills out a …

Apps Script Basics – Loops

Here, we’re going to look at loops and how they can make repetitive tasks really easy and how they can save you so much coding. For example, if we …

Apps Script Basics – 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 …

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. …

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 …

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 …

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 …

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 and over again, …

Web Development

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 …

Python Programming

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 …

Python Programming

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

Trevor Fox<p>January 30, 2017<p>(This post has been moved to a site all about Google Apps Script Tutorials.)<p>If you are new to Google Apps Script or …

JavaScript

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 …

Google Apps

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

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 …

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 …