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
Category: Forms
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
Apps Script – Issues reporting form, log & email
In this post, we’ll look at a way to create a quick and simple system to report maintenance and IT issues in the classroom. The teacher fills out a Google Form on their phone, this gets logged on a Google Sheet, and as we work in a multilingual environment, it uses Google Translate to automatically… Continue reading Apps Script – Issues reporting form, log & email
Questionnaires – Automatically send feedback to individuals
It’s common to use questionnaires at the end of a course to get feedback on the course and teacher. When you have a lot of teachers, it can be hard work analysing that feedback and splitting into the different teachers. Here we’re going to look at how we can automatically send the individual feedback to… Continue reading Questionnaires – Automatically send feedback to individuals
Placement Test
[et_pb_section bb_built=”1″ admin_label=”section”][et_pb_row admin_label=”row” background_position=”top_left” background_repeat=”repeat” background_size=”initial”][et_pb_column type=”4_4″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left” border_style=”solid” background_position=”top_left” background_repeat=”repeat” background_size=”initial” _builder_version=”3.0.51″ custom_margin=”-100px|||”] Students who want to study a language at a language academy, have to do a placement test, which confirms their current level in that language and then tells the tester in which level they should be placed. Here we’re… Continue reading Placement Test
Apps Script – Clocking in & out system
In this post, we’ll look at setting up a simple clocking in and out system using Google Forms and Sheets. This idea originally came from a real life situation where we had to implement a clocking in and out system to meet a change in Spanish law. With our teachers working both on-site and off-site,… Continue reading Apps Script – Clocking in & out system
Automatically emailing info from a form submission
Here we’ll look at how to set up automatic emails, which contain information submitted by the Google Form user. The beauty of this is that the information is sent to you (and others) without you having to do anything and without you having to check the spreadsheet to see if there has been a submission.… Continue reading Automatically emailing info from a form submission
Request form – Sending automatic emails
One of the most useful things I’ve learnt to do with Google Apps Script, is to email people automatically when a form is submitted. It has countless uses and in this example, we have a user requesting a private class via a Google Form. The relevant parties will receive an email which will contain a short message… Continue reading Request form – Sending automatic emails