You may have hundreds of files on your Google Drive, but if you’re like me, you end up only using certain ones all the time. Drive has a couple of options to help you get to those files or folders quickly. 1) Starring them; 2) Using Quick Access which predicts what files you will need.… Continue reading Google Drive – Quick access to your files
Author: bazroberts
Google Sheets – Controlling Rows & Columns (Part 1)
In this post, let’s look at various ways you can modify the rows and columns on your sheet. Part 1 (this post) Changing the row size of rows and columns (to fit data / manually / enter size) Selecting a whole row or column Inserting and deleting a row or column Inserting and deleting specific cells… Continue reading Google Sheets – Controlling Rows & Columns (Part 1)
Google Sheets – Formatting your data
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 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