When it comes to mass data entry works, it is essential to use data entry forms to improve accuracy and speed. This tutorial will show you how to create a data entry form in Google Sheets. With Google Sheets, it has many advantages over data entry forms like MS Access installed on your local computer. … Read more
Dependent dropdown lists are a type of dropdown list where the options available in the list depend on the value selected in another dropdown list. This type of dropdown list is useful when you design data entry forms or create dashboards with options to automatically change their content based on the user’s selection. Using dependent … Read more
When creating a Google My Map, the system automatically generates a data table for each layer. You can add rows or columns to this table as you develop the map. When you create a layer by importing data from a spreadsheet, the data in the spreadsheet is saved in the data table of that layer. … Read more
You can create your own maps by adding several other layers on top of the Google Map using the Google My Maps feature. Once you create your custom maps, you can share it with your team or anyone. You can view it on any device. In this post, I will show you how easily you … Read more
Using the DirectionFinder class of Google Apps script, you get directions between locations from Google Maps. This class returns several details, including travel time and distance between the given two locations. In this tutorial, I will show you how to get Google Map Travel Tim and Distance to Google Sheets automatically using Google Apps Script. … Read more
Google Drive is a great cloud storage service that provides you with 15 GB of cloud storage free. It is one of the most used cloud storage services and is associated with every Google account. Besides the cloud space, it also provides plenty of applications for free. In this post, I will show you how … Read more
