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 […]
Google Script Authorization: Review and Accept the Permission Guide
Every time you use a Google apps script class in your script that accesses your account or data, Google will inform you and ask for your consent. Also, every time you add a new class that accesses your data you will have to go through the process again. This process is not straight forward like […]
Create an Inventory Management System with Google Form and Spreadsheet
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 […]
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 […]
Share Google Forms Summary of Responses Without Giving Access
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 […]
Create a Script to Send Emails from Google Sheet
Sending the same email but with some personalized content to a group of people can be a boring and time-consuming process. The best solution to this is to have all the data in the sheet and use a process called MailMerge. But this option is not available in google sheets. So, in this how-to, we […]