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
Month: April 2017
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