How to Create a Button in Google Sheets to Run Scripts

How to Create a Button in Google Sheets to run Scripts

You can create a button in Google Sheets to run Apps Script from its user interface. The button is essential when you design Google Sheets for others who do not know App Scripts. This post will show you how you can create a button in Google Sheets and attach the Google Apps Script function to … Read more

Creating Forms in Google Sheets – Sidebar & Modal Dialog forms

Creating Forms in Google Sheets - Sidebar, Modeless and Modal Dialog forms

There are several ways to create forms in Google Sheets. The most popular and easiest method is to use Google Forms. However, it is a general-purpose form-building application. Sometimes you may find it very difficult to create a form in your mind with Google Forms. Especially when it comes to mass data entry works, you … Read more

How to Create an Online Data Entry Form that can Perform CRUD Operations on Google Sheets

Create an HTML Web App to CRUD Records on Google Sheets_

Online data entry forms are a powerful tool that you can use to collect many types of data more easily and accurately. Google Sheets is the most powerful cloud-based spreadsheet application that you can use absolutely free. Google is also offering another free tool named Google Apps Script (GAS) to increase the power of your … Read more

Multi-Row Dependent Dropdown List in Google Sheets

dependent dropdown list in google sheets

In a previous post, I explained how to create a simple dependent dropdown list in Google Sheets. However, using that method you cannot copy the dependent dropdown list into multiple rows. As such, in this tutorial, I will show you how you can create a dependent dropdown list in Google Sheets and copy it into … Read more

8 ways to keep track of what you read online

keep track of what you read online

You may read several online articles/ blog posts a day. Sometimes you may forget what you read, and again another day, you will search for the same article again on Google search. Instead of reading and just leaving the articles, you keep track of what you read online. When you track reading, you will get … Read more

How to Create Data Entry Form with Google HTML Service and Submit Data to Google Sheets

How to Create Data Entry Form with Google HTML Service and Submit Data to Google Sheets

Data entry is one of the important steps in the data analysis process. It is important that the data collected is correctly entered into the electronic format. A good data entry form can reduce the number of human errors added during the data entry. A correctly designed data entry form can speed up data entry … Read more

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 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

Automate Google Sheet to get Google Map Travel Time and Distance

Automate Google Sheet to 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