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)
Apps Script
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
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 in Google Form Quiz
Finally, I found 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 in 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