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
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 Responses Without Giving Access
There is a couple of ways you can share Google Forms responses. You can collect the answers in Google Spreadsheet, make charts, and share them. Maybe insert the charts on a google site to look more professional. Anyway, 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 check … [Read more...] about Share Google Forms Responses Without Giving Access
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 will create a script to send emails from google sheet using the data from the … [Read more...] about Create a Script to Send Emails from Google Sheet
How to Use Google Meet for Distance Learning
Google Meet is an app for video conferencing and it is a part of the G Suit. Now, in the situation with coronavirus and stoping the classic classroom learning, educational institutions that have G Suit for Education can now use the Google Meet app and start the classes online, the famous distance learning.What can you do with Google Meet for your online teaching:start, … [Read more...] about How to Use Google Meet for Distance Learning