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
Google Workspace Tutorials
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
Questionnaires – Automatically send feedback to individuals
It’s common to use questionnaires at the end of a course to get feedback on the course and teacher. When you have a lot of teachers, it can be hard work analysing that feedback and splitting into the different teachers. Here we’re going to look at how we can automatically send the individual feedback to… Continue reading Questionnaires – Automatically send feedback to individuals
Apps Script Basics (2) – First Docs and Forms Scripts
[et_pb_section bb_built=”1″ admin_label=”section”][et_pb_row admin_label=”row” background_position=”top_left” background_repeat=”repeat” background_size=”initial”][et_pb_column type=”4_4″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left” border_style=”solid” background_position=”top_left” background_repeat=”repeat” background_size=”initial” _builder_version=”3.0.50″ custom_margin=”-100px|||”] 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 you can access Docs and Forms, not just Sheets with… Continue reading Apps Script Basics (2) – First Docs and Forms Scripts
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 to do. So, to make your life easier, here’s a script, which will set up your folders for you. I’ve made it so there is a little bit… Continue reading Apps Script – Creating & sharing Class folders in Drive
Apps Script Basics (1) – 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. This post is for those taking their first steps into writing code, so I will explain everything step-by-step. First Google Sheets Script First, you’ll… Continue reading Apps Script Basics (1) – First Script
Create a Placement Test with Google Forms & Sheets
Students who want to study a language at a language academy, have to do a placement test, which confirms their current level in that language and then tells the tester in which level they should be placed. Here we’re going to see how a combination of Google Forms and Sheets, the functions VLOOKUP and ARRAYFORMULA and conditional formatting,… Continue reading Create a Placement Test with Google Forms & Sheets
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 situation where we had to implement a clocking in and out system to meet a change in Spanish law. With our teachers working both on-site and off-site,… Continue reading Apps Script – Clocking in & out system