In this post, we’re going to look at how to add titles and sections. Plus, how you can move sections and preview your form. If you’ve got a longer form, you’ll probably want to add sections and possible pages to your form. There is an important difference between titles and sections. Titles – These add… Continue reading Google Forms – How to add titles and sections
Category: Forms
Learn useful Google URL tricks to make your online easier
In this post, we’re going to look at several useful Google URL tricks which allow us to quickly do a whole range of things, like quickly create documents, provide links to copy master templates, and from a link automatically download a PDF version of a document, and many more. We’re going to look at….. Useful… Continue reading Learn useful Google URL tricks to make your online easier
Forms & Sheets – Attendance System
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
Online exam maker using Apps Script
With all our classes moving from 99% face-to-face to 100% online, we had the situation where we needed to carry out all our exams online too. A relatively easy solution was to use Google Forms, which was easy for students to fill out and for us to receive the answers. The only issue is the… Continue reading Online exam maker using Apps Script
Parents Evening Appointment System – Part 3
In this final part of a 3-part post (see part 1 and part 2), we’re going to look at how we get the parents form submissions, send them a confirmation email with the appointment details, and record the appointment on the appointment list for the teacher. The main steps are: Get the form responses. Get… Continue reading Parents Evening Appointment System – Part 3
Parents Evening Appointment System – Part 2
This is part 2 of a 3-part post on setting up a parents evening appointment system. Part 1 looked at setting up the documents and in particular the pre-filled form links. Here, we’re going to look at the code which will create the forms for each class and which will create appointment list sheets for… Continue reading Parents Evening Appointment System – Part 2
Parents Evening Appointment System – Part 1
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
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