How to create a Data Entry form in Google Sheets

How to create a Data Entry form in Google Sheets

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 you can create a data entry form in Google Sheet. With Google Sheets, it has many advantages over data entry forms like MS Access installed on your local … Read more

How to Create a Dependent Drop-Down List in Google Sheets

Dependent Drop-Down List

The drop-down lists are useful when you are creating data entry forms or creating interactive dashboards to visualize your data. Sometimes, you may need to create drop-down list depending on another dropdown list, in other words, a dependent drop-down list. In this tutorial, I will show you how to create a second drop-down list, which … Read more

Automate Google Sheet to get Google Map Travel Time and Distance

get Google Map Travel Time and Distance

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