How to use Google Sheets to Manage Data Entry Works

How to use Google Sheets to Manage Data Entry Works

“Garbage in, garbage out” is a common saying in the computer world to describe how important the quality of the data is. If your input nonsense data, you will also get a nonsense output. So, to get more accurate results, you should minimize the errors in your data. Error in data entry is one such … Read more

Upload files to Google Drive with Google Apps Script Web Apps

Upload files to Google Drive with Google Apps Script Web Apps

We have created a number of Google Apps Script Web Apps that can be used for data collection purposes in our previous blog posts. We included several types of form controls in those web apps, such as text fields, dropdowns, radio buttons, etc… This blog post will show you how to create a web app … 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 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