In this post, we’re going to look at automatically setting up validation on a form. Validation allows us to control what the user inputs on the form, for example, to make sure they enter a number, make sure they write more than 10 words, etc. Clocking in and out form In the example below, we’re… Continue reading Apps Script Basics – Form validation
Category: Apps Script Posts
Apps Script Basics – Using Form Responses
In this post, we’re going to look at how we can work with the responses a form user submits. We’ll look at two main ways, 1) Getting the form responses from a Google Sheet, 2) Getting the form responses directly from a Google Form. To show some practical uses of this, we’ll do the following:… Continue reading Apps Script Basics – Using Form Responses
Apps Script Basics – Creating & updating a multiple question form
Following on from my previous post on creating and updating Google Forms, here we’ll look at adding and updating multiple questions to a form. Creating multiple questions in a Google Form Here in a Google Sheet, I have a set of reading comprehension questions, which I want to add to a Google Form. There are… Continue reading Apps Script Basics – Creating & updating a multiple question form
Apps Script Basics – Range Class & Triggers (pt 1)
In this post, we’re going to look at some of the ways you can control the cells on your spreadsheet, using the methods connected to the Range class. At the time of writing, there were nearly 200 different methods connected to this class. So, as you can imagine there are a lot of different things… Continue reading Apps Script Basics – Range Class & Triggers (pt 1)
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 following: If, else if, and else statements – to allow the program to make decisions Create your own menu in the spreadsheet to run… Continue reading Apps Script Basics – if, prompt, menu, & onOpen trigger
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, then email them to the parents. This could of course be adapted to send any types of reports. The teachers will fill in the spreadsheet and as its a… Continue reading Make & Send Kids Reports
Apps Script Basics – Arrays, Execution log
In this post, we’re going to look at another key area in JavaScript and Apps Script and indeed in many coding languages, that of arrays, which are just special variables which allow you to store multiple elements in a single variable. I’ll also introduce you to the Execution log, where you can see what’s happening… Continue reading Apps Script Basics – Arrays, Execution log
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. The teacher fills out a Google Form on their phone, this gets logged on a Google Sheet, and as we work in a multilingual environment, it uses Google Translate to automatically… Continue reading Apps Script – Issues reporting form, log & email
Apps Script Basics – Loops
In this post, 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. One of the things computers are good at is doing repetitive tasks quickly and accurately. For example, if we want to print the word Hello! a number of times down a… Continue reading Apps Script Basics – Loops
Apps Script Basics – Variables and getting & setting values
In this post, we’re going look at how variables are set up and how they can store various pieces of information. We’re also going to look at reading and writing data from a spreadsheet, which is one of the most common tasks when working with one. I’m going to use a simple example, where we have… Continue reading Apps Script Basics – Variables and getting & setting values