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

How to GApps

Your life changer for G Apps

Forms

Add Auto Number to Google Form Response Sheet

February 27, 2020 by SavoE

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

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

Create daily sales report sheets from Google Form

January 27, 2020 by SavoE 1 Comment

add series bar chart for scattered data

There is a lot of small businesses that cannot afford a full-featured app to do their reports. They usually use a spreadsheet to analyze their data. The biggest problem with this is that the process to enter the data on a daily basis is hard and time-consuming, especially for daily sales report sheets. To automate this process and save some time it is best to set up and collect … [Read more...] about Create daily sales report sheets from Google Form

Google Forms Spreadsheet Data Analysis

December 31, 2019 by SavoE Leave a Comment

use filter function to analyze data from Google Forms

If you are not satisfied with the Google Forms built-in tool for analyzing responses, you can select google spreadsheet as a response destination and analyze the data there.It is very easy if you have a Form that is like a survey, you collect all the responses at once and then do the analyses. You have all the responses, you can select what to copy and paste and then you … [Read more...] about Google Forms Spreadsheet Data Analysis

Google Forms Settings

December 17, 2019 by SavoE Leave a Comment

To access the Google Forms settings menu, you have to click the gear icon on the top right corner of your form. From here you can access a set of options you can perform on your Form. From restricting on who has access to the form to make your form act as a quiz test.In this article, we are going to explain all of the settings available from the settings menu. Google Forms … [Read more...] about Google Forms Settings

« Previous Page
Next Page »

Primary Sidebar

Follow me on Twitter

Follow @HowToGApps

More to See

Google Sheet Template Sales

Google Sheet Template to Track Sales of Products or Services

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

Google spreadsheet prank

Google Spreadsheet Prank

print merge and mail merge for Google Docs

Print Merge or Mail Merge for Google docs

spreadsheet with certificate templates and print merge script

Google Sheets Free Certificate Templates + Print Merge Script (email/PDF)

Recent Comments

  • Cordial on Automated e-card sender – Google Spreadsheet Script to Send Birthday Cards via Email
  • LinkyChan on Close the Google Form and Force the User to Submit the Responses
  • SavoE on Close the Google Form and Force the User to Submit the Responses
  • LinkyChan on Close the Google Form and Force the User to Submit the Responses
  • Chartist on Explode or expand a Pie Chart in Google Sheets

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




Recent Posts

  • Simple Google Sheets Ticketing System – Free Web App Setup & Deployment Guide
  • Create Google Docs from Google Sheets Using Google Apps Script
  • Ultimate Guide: Create and Publish a Google Sheets Web App with Google Apps Script
  • How to Get Email Notifications from Google Forms Using Apps Script
  • Google Sheets: Auto-Insert Charts with Apps Script

Recent Comments

  1. Cordial on Automated e-card sender – Google Spreadsheet Script to Send Birthday Cards via Email
  2. LinkyChan on Close the Google Form and Force the User to Submit the Responses
  3. SavoE on Close the Google Form and Force the User to Submit the Responses
  4. LinkyChan on Close the Google Form and Force the User to Submit the Responses
  5. Chartist on Explode or expand a Pie Chart in Google Sheets

How to GApps

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

Footer




Recent

  • Simple Google Sheets Ticketing System – Free Web App Setup & Deployment Guide
  • Create Google Docs from Google Sheets Using Google Apps Script
  • Ultimate Guide: Create and Publish a Google Sheets Web App with Google Apps Script
  • How to Get Email Notifications from Google Forms Using Apps Script
  • Google Sheets: Auto-Insert Charts with Apps Script

Search

Copyright © 2025 · How to Gapps