For my culture, the Christmas season has come. With it comes all the delightful homemade goodies and snacks you get for over the Christmas season.
I do like to cook and over the years I have either inherited or discovered some great recipes. However, one of the problems I often face is that I need to be able to change the batch size or total ingredient weight of my recipe for when it is just me and Mrs Yagi or when I am hosting a bunch of people for a Christmas party.
So rather than try and calculate the changes each time, I put our recipes into a Google Sheet and set it up so that I could plug in a number of batches or a total ingredient weight and then head out and do my shopping accordingly.
Google Sheets provides an email notification tool that allows you to get email notifications for changes to a Google Sheet or when a Google Form that is connected to your Google Sheet receives a submission. You can set your email notifications to be received when each change occurs or as a daily summary.
There are some really good use-cases where you might need to receive notifications of changes to a Google Sheet. Here are two common examples that I have used notifications for in the past:
Tech Support: I have had a form connected to a sheet and then had my team use notifications to get an email when a user submits a tech support issue. We set it up so that the first responder adds their initial to a column related to the lastest form submission so that everyone knows that it is being addressed.
Project Management: I’ve run a Gantt chart for project management and when someone from a project I have assigned has completed a portion of a task and is ready for review, they check a box. At the end of each day, I get an email notification summarising the changes in the chart.
Check out the details below on how to get notifications on a Google Sheet and how to read the email notification summary.
How to prevent editors from moving columns and rows
You can prevent editors from moving columns and rows by selecting a range of rows, for example, A1:E1and preventing the user from editing those cells. Now when the editor tries to move any of those columns, they will not be able to.
check out the video tutorial below for more on this:
Google Apps Script: WebApp [updated Dec 2021 – With thanks to Greg S]
In this tutorial, we will cover how you can get a unique temporary access key from a user accessing your WebApp that lasts for 30 days.
Temporary access keys allow you to track users as they use your WebApp over time while still providing anonymity to the user by providing only an access key to that user. Rather than, say, use their name or email address.
Why is this important? Well, you might want to limit the number of times a user submits a form on your WebApp. If you can get a user’s access key unique to them then you can store the number of attempts by the user and check it before the data is submitted.
For example, in a previous post, we created a chain story that we might want to limit the number of times our users contribute to our story to once a day.
NOTE! This tutorial is pretty much standalone. However, it will require some basic knowledge of Google Apps Script WebApp and HTML. Don’t worry if some basic setup parts are not covered in this tutorial, I’ll link to how to do these bits if you need some more instruction.