Category: Apps Script

Apps Script Basics – Authorising a script

[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”3.21.1″ custom_margin=”0px||” custom_padding=”0px||”][et_pb_row custom_padding=”0px||” admin_label=”row” _builder_version=”3.21.1″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”][et_pb_column type=”4_4″ _builder_version=”3.0.47″][et_pb_text admin_label=”Text” _builder_version=”3.21.1″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”0px||”] To allow your scripts to run, you will need to authorise them. Below are the steps which show you how to do this: Click the play button on the toolbar. 2. A dialogue box will… Continue reading Apps Script Basics – Authorising a 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