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

How to G Apps

Your life changer for G Apps

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

Forms

Embed Google Form, Sheet, Chart and Doc in WordPress

December 22, 2020 By SavoE 2 Comments

publish to the web Google Sheets

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

August 31, 2020 By SavoE 22 Comments

Google Form Script to Auto Fill 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

August 21, 2020 By SavoE 18 Comments

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

August 3, 2020 By SavoE 57 Comments

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

Create an Inventory Management System with Google Form and Spreadsheet

July 12, 2020 By SavoE 84 Comments

create inventory management system f

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

June 4, 2020 By SavoE 80 Comments

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

Share Google Forms Summary of Responses Without Giving Access

May 28, 2020 By SavoE 8 Comments

print Ctrl+P summary of responses

There is a couple of ways you can share Google Forms summary of responses. You can collect the answers in Google Spreadsheet, make charts, and share them. Maybe insert the charts on google site to look more professional. But this will take a lot of time to do, so you can just give access to your Form, the option "Add collaborators", and people can go to the responses tab and … [Read more...] about Share Google Forms Summary of Responses Without Giving Access

Google Spreadsheet Script to create and email a PDF on Form Submission

March 5, 2020 By SavoE 407 Comments

script to create and email a PDF

In this how-to, we will use a script to create and email a PDF on Form submission automatically. So, this script is going to be triggered by submitting the Google Form and it will convert the sheet in PDF. In the next steps, the script is going to save the PDF in your Drive and send it as an attachment in an email.Check this article if you want to AutoFill and Email a Doc … [Read more...] about Google Spreadsheet Script to create and email a PDF on Form Submission

Add Auto Number to Google Form Response Sheet

February 27, 2020 By SavoE 51 Comments

To easily and uniquely identify each Google Form response is to have a key field. That field should be in the form of a number that will be autogenerated to avoid duplicates. This option is not available in Google Forms, so you have to adapt the Form response sheet to do it for you.The auto-number formulaThe formula that we are going to use to add auto number to Google … [Read more...] about Add Auto Number to Google Form Response Sheet

Generate Invoices using Google Form and Sheets

February 24, 2020 By SavoE 52 Comments

generate invoice google forms and sheets

In this guide, we are going to build a small web app to generate invoices using Google Form and Sheets. Basically, we are going to create a Google Form that collects the data for the invoice and sends it to a spreadsheet. In the spreadsheet, we are going to create an invoice template for printing and we are going to use formulas to get the latest data automatically.So, just … [Read more...] about Generate Invoices using Google Form and Sheets

Next Page »

Primary Sidebar


Inspire me to keep the website up and running.

Latest How Tos

Automated e-card sender – Google Spreadsheet Script to Send Birthday Cards via Email

Automated e-card sender – Google Spreadsheet Script to Send Birthday Cards via Email

Review and Accept the Permission Guide

Google Script Authorization: Review and Accept the Permission Guide

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

insert text box in new google sites

Create a Google Site and Insert Charts from Spreadsheet

add series bar chart for scattered data

Create daily sales report sheets from Google Form

Recent Comments

  • Hossam on Google Spreadsheet Script to create and email a PDF on Form Submission
  • Fulvio on Create an Issue Tracking System with Google Form and Spreadsheet
  • Fulvio on Create an Issue Tracking System with Google Form and Spreadsheet
  • SavoE on Google Spreadsheet Script to create and email a PDF on Form Submission
  • Hossam on Google Spreadsheet Script to create and email a PDF on Form Submission
  • Hossam on Google Spreadsheet Script to create and email a PDF on Form Submission
  • Sapna Jha on Create an Issue Tracking System with Google Form and Spreadsheet
  • Uday on Add Auto Number to Google Form Response Sheet
  • SavoE on Google Spreadsheet Script to create and email a PDF on Form Submission
  • SavoE on Google Spreadsheet Script to create and email a PDF on Form Submission


Inspire me to keep the website up and running.

Copyright © 2021 · How to Gapps

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

Non-necessary

Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.

SAVE & ACCEPT