Whit this Google Form Script you can Automatically Add the "Other:" response from the multiple-choice question or checkbox question to the list of choices for the next user.There is a plugin for that, but this way you can just paste the script in your Google Form and it will automatically work for you by adding "Other" responses into the list of choices.So, when a user … [Read more...] about Google Form Script to Automatically Add New Choices from “Other:” Form Responses
Google Form to PDF (save to Drive and/or send it in email)
This solution will create a PDF file from a Google Form submission using a Google Doc as a template. You can also use a Google Spreadsheet or a Slide as a template with just a few simple modifications.Generally, you have a plugin for this, but I suggest not to use one because you just need a simple script and without any knowledge in Google script you can implement it in … [Read more...] about Google Form to PDF (save to Drive and/or send it in email)
Automated e-card sender – Google Spreadsheet Script to Send Birthday Cards via Email
Sending an email to wish your customers a happy birthday it's usually a thing that big companies do. There is a good reason for that, it's an expensive upgrade to the system you are using, or simply you need to get an external app and pay a monthly subscription.But, you can make your own system for free using only a simple script and a Google Spreadsheet. This automated … [Read more...] about Automated e-card sender – Google Spreadsheet Script to Send Birthday Cards via Email
Embed Google Form, Sheet, Chart and Doc in WordPress
You have a plugin for that too, but adding more plugins to your WordPress site can make it slower, and trust me, you don't need one for this. It's easy and you don't have to be an expert to throw in a Google Form or a chart from a Google Spreadsheet to your WordPress post. Embed a Google Form in WordPress post (classic and block editor) First, you need to get the embed code … [Read more...] about Embed Google Form, Sheet, Chart and Doc in WordPress
Google Form Script to AutoFill and Email a Doc Template
I have used a similar solution for creating documents from a template, but it was a spreadsheet script and used a sheet as a template. Later on, I switch to a Google Doc template, as it was easier for my coworkers to change the content.Since nobody here was interested in the spreadsheet, I decided to readapt the Script to work from Google Form and directly create the … [Read more...] about Google Form Script to AutoFill and Email a Doc Template
Add Timer to Google Form Quiz
Finally, I fund a way to add a timer to a google form, and yes, it forces the user to submit the form after a given time. It's not like all the other plugins that will only close the form to not accept responses and the users that are in the process of filling in the form will lose their answers. Imagine the student who spends an hour answering the question to be only 1 minute … [Read more...] about Add Timer to Google Form Quiz
Create an Issue Tracking System with Google Form and Spreadsheet
Based on the solution in this how-to you will be able to build a Ticketing System, also known as Issue Tracking System, using Google Form, Google Spreadsheet, and Google Script. The solution is very simple to implement and you can easily add some more functionality and use it on the go.Basically, with this Issue tracking system you can:Open a TicketEnter the Issue … [Read more...] about Create an Issue Tracking System with Google Form and Spreadsheet
Google Script Authorization: Review and Accept the Permission Guide
Every time you use a Google apps script class in your script that accesses your account or data, Google will inform you and ask for your consent. Also, every time you add a new class that accesses your data you will have to go through the process again.This process is not straight forward like click here to accept permissions, you will have to deal with a couple of dialogs, … [Read more...] about Google Script Authorization: Review and Accept the Permission Guide
Create an Inventory Management System with Google Form and Spreadsheet
I know you have your Spreadsheet where you track your Stock/Inventory list and probably you have formulas there to do analysis on the data, and some pivot tables and charts. But you have to be on your computer to add or reduce the quantity or check the current status. This solution is very simple and you can use it on your mobile and check the Inventory on the go.With this … [Read more...] about Create an Inventory Management System with Google Form and Spreadsheet
Google Sheets Script for Auto Numbering Google Form Responses
In the previous article, Add Auto Number to Google Form Response Sheet, we used a formula to automatically add numbers to Google Form responses in the sheet. The formula was easy to implement and you can also use text mixed with numbers. But the main problem with using this solution is that it always resets the numbering, so if you delete a response all the following responses … [Read more...] about Google Sheets Script for Auto Numbering Google Form Responses