This is the first of a three-part post, where we’re going to look at how you can create an appointment system using Google Forms and Sheets and with the use of Apps Script, how you it will update the available times on the forms and how it will send automate confirmation emails to those making the appointments.… Continue reading Parents Evening Appointment System – Part 1
Google Workspace Tutorials
Apps Script Basics – Making quizzes in Google Forms
In this post we’re going to look at how you can set up a Google Forms quiz with Apps Script. As an example, I’m going to take you through the example that was posted on the G Suite Developers blog here. I’ve tweaked it a little just to create a new form instead of editing… Continue reading Apps Script Basics – Making quizzes in Google Forms
Apps Script Basics – Form page navigation
In this post, we’re going to expand on my previous post on setting up form validation and improve the clocking in and out form we set up, so that the same form can be used for different employees. We’re going to use this example to see how page navigation can work, both to move to… Continue reading Apps Script Basics – Form page navigation
Apps Script Basics – Form validation
In this post, we’re going to look at automatically setting up validation on a form. Validation allows us to control what the user inputs on the form, for example, to make sure they enter a number, make sure they write more than 10 words, etc. Clocking in and out form In the example below, we’re… Continue reading Apps Script Basics – Form validation
Apps Script Basics – Using Form Responses
In this post, we’re going to look at how we can work with the responses a form user submits. We’ll look at two main ways, 1) Getting the form responses from a Google Sheet, 2) Getting the form responses directly from a Google Form. To show some practical uses of this, we’ll do the following:… Continue reading Apps Script Basics – Using Form Responses
Apps Script Basics – Adding different types of questions to a Form
In this post, we’re going to look at how we can add different types of questions to a Google Form from a Google Sheet. As an example, we’re going to create a questionnaire with 9 different question types. In our sheet we have the questions and various options we’re going to use. Column B has… Continue reading Apps Script Basics – Adding different types of questions to a Form
Apps Script Basics – Creating & updating a multiple question form
Following on from my previous post on creating and updating Google Forms, here we’ll look at adding and updating multiple questions to a form. Creating multiple questions in a Google Form Here in a Google Sheet, I have a set of reading comprehension questions, which I want to add to a Google Form. There are… Continue reading Apps Script Basics – Creating & updating a multiple question form
APPS SCRIPT BASICS – Creating & updating a Google form
In this post, we’re going to look at how to create a Google Form with a multiple-choice question. We’ll look how you can create the form from data in the script, then look how it can be done taking data from a Google Sheet. In the final example, we’ll look at how we can update… Continue reading APPS SCRIPT BASICS – Creating & updating a Google form
Google Drive – Quick access to your files
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
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)