You want to prank your coworker, use this Google Spreadsheet prank script and it will turn a sheet into a message using cells. You can add your own message, just change the text on line 155, but you have to keep it short.Here is what will happen if somebody tries to edit a cell:So, the prank (the script) will make a copy of the sheet that is edited and, letter by … [Read more...] about Google Spreadsheet Prank
Apps Script
Print Merge or Mail Merge for Google docs
Google Docs doesn't have the Print Merge or a Mail Merge option available, so if you want to create multiple documents from the data you have in your spreadsheet you have to use an Add-on. Usualy these add-ons have limited options and are missing some of the needed functions. I have been using this Google spreadsheet script to do a Print merge for a while and I have made small … [Read more...] about Print Merge or Mail Merge for Google docs
Google Form to Slides + Save to Drive and/or send it in email as a PDF
On your request, as an addition to the how-to: Google Form to PDF (save to Drive and/or send it in email), here is a script to create a new Google Slide from a slide template and save it to PDF or send it in an email.So, this Google Form script will open a Google Slide presentation and replace the text with the text from the Form, and then it will save it as a new Google … [Read more...] about Google Form to Slides + Save to Drive and/or send it in email as a PDF
Google Form Script to Automatically Add New Choices from “Other:” Form Responses
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)