Once you’ve added your data onto a sheet, you’ll probably want to format it in some way. In this post, we’ll look at formatting data in Sheets. By default, numbers entered are considered just that, normal numbers, but sometimes you want specific types of numbers, e.g. percentages, currency, dates, times, scientific, numbers to certain decimal points.… Continue reading Google Sheets – Formatting your data
Google Workspace Tutorials
Google Sheets – Cell formatting
The fundamental building blocks of any spreadsheet are the cells. So clearly, it’s important to understand how to use them well. In this post, I will focus on the various ways you can format cells, so that the cells display the information you want, visually look professional and most importantly, will help you understand your… Continue reading Google Sheets – Cell formatting
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 (9) – Sheet Class
[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”3.0.47″][et_pb_row admin_label=”row” _builder_version=”3.0.47″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”][et_pb_column type=”4_4″ _builder_version=”3.0.47″ parallax=”off” parallax_method=”on”][et_pb_text admin_label=”Text” _builder_version=”3.0.47″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_margin=”-100px|||”] In previous posts, we’ve looked at the SpreadsheetApp and Spreadsheet classes. Now let’s look at the next level down, which is the Sheet class. Here, we’ll look at how we can work with sheets in a… Continue reading Apps Script Basics (9) – Sheet Class
Apps Script Basics (8) – Spreadsheet Class
[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”3.0.47″][et_pb_row admin_label=”row” _builder_version=”3.0.47″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”][et_pb_column type=”4_4″ _builder_version=”3.0.47″ parallax=”off” parallax_method=”on”][et_pb_text admin_label=”Text” _builder_version=”3.0.47″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_margin=”-100px|||” use_border_color=”off” border_color=”#ffffff” border_style=”solid”] 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 class. This class allows us to: copy spreadsheets work… Continue reading Apps Script Basics (8) – Spreadsheet Class
Apps Script Basics (7) – 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 area, SpreadsheetApp to then create some spreadsheets. We’re also going to see the really useful for in loop in action. It’s important to have an understanding of how the… Continue reading Apps Script Basics (7) – SpreadsheetApp & for in loop
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