In this post we’re going to make an attendance system using Google Forms and Sheets. The user will fill in the attendance on the form (possibly on their mobile) and the data will then be stored and organised automatically per student. This will also use a Form add-on called FormRanger to easily populate a Google Form… Continue reading Forms & Sheets – Attendance System
Category: Posts
Create a Book inventory with Google Sheets & Apps Script
Here we’re going to make a simple book inventory, where we’ll be able to control the location of the books and also find out where a book is. This uses a mixture of GAS code and Sheets functions. We’ve got 3 sheets: Front page – This is what the user will see and use. In… Continue reading Create a Book inventory with Google Sheets & Apps Script
Google Sheets Functions – QUERY
The QUERY function is in a category all on its own. It’s an extremely powerful function that will let you filter, sort, group, pivot, basically extract data from a table and present it in numerous ways. At first it can look daunting, with its own language and syntax, but once you dip your toe into the… Continue reading Google Sheets Functions – QUERY
Sheets Functions – WEEKDAY, WORKDAY, NETWORKDAYS, EDATE, EOMONTH
Following on from my post on the basic date functions, let’s look at some really useful functions that work with dates, namely: WEEKDAY, WORKDAY, NETWORKDAYS, EDATE and EOMONTH, plus we’ll see an example with the CHOOSE function. With these we’ll: Find out the day of the week of a particular date Work out a deadline date Work… Continue reading Sheets Functions – WEEKDAY, WORKDAY, NETWORKDAYS, EDATE, EOMONTH
Google Drive (6) – How to manage files and folders
You’ve got into Google Drive, now you need some files and folders to store in it. Let’s go through the most common actions you do with files and folders: creating, naming, copying, and deleting. ‘Moving’ I will cover in a different post as there are different ways to do this. Creating a file As an… Continue reading Google Drive (6) – How to manage files and folders
Google Drive (5) – How does it work?
In this post, I’m going to explain what Google Drive is and give you an overview of how it works. When you log into Google Drive, your computer connects to the place where your files are stored. This is ‘in the cloud’ which is actually a physical storage place somewhere in the world, in this… Continue reading Google Drive (5) – How does it work?
Google Drive – The menus (part 3)
At the top of the screen is the search bar and account options. Search bar It’s no surprise that Google includes a powerful search engine so you can find your files, without having to hunt for them via the folders. Just type in the words you want and press Enter. Google will search for filenames… Continue reading Google Drive – The menus (part 3)
Google Drive – The menus (part 2)
In this post, I’ll briefly go through the options on the bar above the files and folders area. The bar above the files and folders area, contains some more Drive options and also where you can find the location of a file of folder, via the breadcrumbs. Without a file or folder selected, you’ll see four… Continue reading Google Drive – The menus (part 2)
Google Drive – The menus (part 1)
Once you’ve logged in to your account and clicked on Drive, you’ll be presented with the main Drive page. There are 4 main areas: 1) In the middle is where you will see your files and folders. 2) On the left, you have some Drive options and filters. 3) On the bar, there are more… Continue reading Google Drive – The menus (part 1)
Google Drive – How to access it
You’ve got a Google account, so how do you access your Google Drive and its contents? 3. Type in your username, i.e. the part before “@gmail.com” in your Gmail address. E.g. brgablog@gmail.com > type in: brgablog Press “Next”. 4. This takes you to the password screen. Type in your password and click “Sign In”. 5.… Continue reading Google Drive – How to access it