In this post, we’re going to look at template literals. What can you do with them? Uses of template literals Mixing single and double quotes First of all, these live in between back-ticks (`) instead of single or double quotes. e.g. This then means we don’t have to worry about what type of quotes we’re… Continue reading JavaScript – Template Literals
Posts
Automatically format rows for Google Form responses
Here, we’re going to see how we can automatically format rows on a Google Sheet when a Google Form response is submitted. When the form responses come in normally, they have the default format below. But I want them to be formatted as below. So, changing the cell backgrounds to red, only showing the day… Continue reading Automatically format rows for Google Form responses
Quickly format multiple Google Sheets with Apps Script
In this post, we’re going to see how we can very quickly format multiple Google Sheets with a little help from Apps Script. The idea of this post, came from the Department of Education in Hawaii, where they have about 300 schools and a guy who works there told me he had to format about… Continue reading Quickly format multiple Google Sheets with Apps Script
Style your Google Site with themes
When the new version of Google Sites first came out you had very limited options to style it but that’s all changed and now you can use themes to not only style the way you want it but to save and share those styles between sites. In this post, I’m going to show you all… Continue reading Style your Google Site with themes
Using Google Meet directly from Sheets Docs & Slides
In this post, we’re going to look at how we can quickly access Google Meet directly from Google Sheets, Docs, and Slides. From April 2022, Google added the ability to open a Meet directly from a Sheet, etc and where the Meet will then appear in the sidebar, allowing you to collaborate on the document… Continue reading Using Google Meet directly from Sheets Docs & Slides
Importing Amazon royalty data from Excel to Google Sheet
In this post we’re going to look at how we can get data from an Excel spreadsheet and import some of it into a Google Sheet. As an example, we’re going to upload an Excel which contains the current month’s royalty data from Amazon and add it to a central sheet which contains all the… Continue reading Importing Amazon royalty data from Excel to Google Sheet
How to use the Google Calendar Appointment System
Google recently improved their appointment system on Google Calendar, which allows people to book appointments directly on your calendar. It’s a great, simple system that may negate the need for 3rd party appointment solutions. However, as you’ll see below it does have one flaw, which means we can’t use it for all our situations. Creating… Continue reading How to use the Google Calendar Appointment System
Calculate hours worked from Google Calendar
In this post, we’re going to see how we can use Google Calendar to record the number of hours we’re working to make sure not overworking! On my Google Calendar I add events to show the periods I’m working (in this case on admin). A script will then get these events and list all of… Continue reading Calculate hours worked from Google Calendar
Remove and separate duplicates in Google Sheets
In this post, we’re going to look at how we can remove duplicates from a list on Google Sheets and also store those duplicate rows on a separate sheet. Google Sheets has a remove duplicates feature but it only removes the duplicates and sometimes you also want to have a list of those. So, here… Continue reading Remove and separate duplicates in Google Sheets
How to use Shared Drives
One of my favourites features of a Google Workspace account is Shared Drives. In this post, we’re going to look at what they are, how to use them and how they differ from My Drive. What is a Shared drive? A Shared Drive lives in your Google Drive and is an addition to your normal… Continue reading How to use Shared Drives