One of the most useful things I’ve learnt to do with Google Apps Script, is to email people automatically when a form is submitted. It has countless uses and in this example, we have a user requesting a private class via a Google Form. The relevant parties will receive an email which will contain a short message… Continue reading Request form – Sending automatic emails
Month: January 2017
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
Google Sheets – INDEX and MATCH (VLOOKUP alt.)
In this post, we’re going to look at how to use INDEX and MATCH to look up data and see how it can be more powerful than the commonly used VLOOKUP. In a previous post, we looked at how we can quickly look up tables for certain information, using the VLOOKUP function. This function is… Continue reading Google Sheets – INDEX and MATCH (VLOOKUP alt.)