• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar
  • Skip to footer
  • Home
  • Forms
  • Sheets
  • General
  • Drive
  • Gmail
  • Sites
  • Apps Script
How to GApps

How to GApps

Your life changer for G Apps

  • About
  • Contact
  • Terms and Conditions
  • Privacy Policy
  • COOKIE POLICY

SavoE

Close the Google Form and Force the User to Submit the Responses

August 7, 2022 by SavoE Leave a Comment

This script will stop the user from adding more entries to the Google Form and will force the user to submit the responses. All the other solutions, like plugins or the options to stop accepting responses, will only stop the form from accepting responses and it will kick the users without the option to send in the answered questions.This function is by far the most … [Read more...] about Close the Google Form and Force the User to Submit the Responses

Google Spreadsheet Prank

November 9, 2021 by SavoE Leave a Comment

Google spreadsheet prank

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

Print Merge or Mail Merge for Google docs

October 8, 2021 by SavoE 5 Comments

print merge and 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 Sheets Free Certificate Templates + Print Merge Script (email/PDF)

June 24, 2021 by SavoE 2 Comments

spreadsheet with certificate templates and print merge script

It's not that easy to find free certificate templates online, there are a lot of results, but a few of them are really free, also there are almost no templates in spreadsheet format. So, I have decided to share my Google Sheets certificate template together with a script that will help you to do a Print Merge and get the Certificates in PDF or send them automatically … [Read more...] about Google Sheets Free Certificate Templates + Print Merge Script (email/PDF)

Google Form to Slides + Save to Drive and/or send it in email as a PDF

June 16, 2021 by SavoE 16 Comments

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

Next Page »

Primary Sidebar

Follow me on Twitter

Follow @HowToGApps

More to See

create inventory management system f

Create an Inventory Management System with Google Form and Spreadsheet

Google Sheets Script for Auto Numbering Google Form Responses

Google Sheets Script for Auto Numbering Google Form Responses

print Ctrl+P summary of responses

Share Google Forms Responses Without Giving Access

Create a Script to Send Emails from Google Sheet

Create a Script to Send Emails from Google Sheet

list of classes in Google Meet

How to Use Google Meet for Distance Learning

Recent Comments

  • SavoE on Automated e-card sender – Google Spreadsheet Script to Send Birthday Cards via Email
  • Brandon on Automated e-card sender – Google Spreadsheet Script to Send Birthday Cards via Email
  • SavoE on Print Merge or Mail Merge for Google docs
  • Claudio on Print Merge or Mail Merge for Google docs
  • SavoE on Print Merge or Mail Merge for Google docs

Buy Me A Coffee
Inspire me to keep the website up and running.




Footer




Recent

  • Close the Google Form and Force the User to Submit the Responses
  • Google Spreadsheet Prank
  • Print Merge or Mail Merge for Google docs
  • Google Sheets Free Certificate Templates + Print Merge Script (email/PDF)
  • Google Form to Slides + Save to Drive and/or send it in email as a PDF

Search

Copyright © 2023 ยท How to Gapps