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 link Google Sheets to Google Maps and create interactive maps

link google sheets to google maps

Most of our day-to-day databases include geographic data such as country, region, city, address, latitude-Longitude, place names, etc. Many of you are used to storing these data on spreadsheets applications like Google Sheets, Microsoft Excel, etc… If you can link these databases to a map, you can see the changes to your data in real-time … Read more

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

How to Create an Online Data Entry Form that can Perform CRUD Operations 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

Create Stunning Free Online Dashboard for your Data

How to Create an Online Dashboard for free to Share and Visualize Your Data

When you are working with databases, you know there are thousands or millions of records in a spreadsheet or your database. These data don’t sense anything when it is in that format. However, if you can represent these data in a graphical form, it is easier to visualize and understand trends, outliers, and patterns in … Read more

Spatial Field Data Collection made easy with Mobile Apps

Spatial Field Data Collection Made Easy with Mobile Apps

The term “spatial data” is used to describe any data related to or containing information about specific locations on the earth’s surface. Hence, many of the field data you collected can be considered as spatial field data. Spatial field data collection involves collecting three types of features, namely points, lines, and polygons. The spatial data … Read more

How to Create Professional Reports with Microsoft Word

How to Create Professional Reports with Microsoft Word

Microsoft Word is one of the most popular word processing tools for creating reports and other documents. Whether you are a student, professional or anyone who does documentation works, proficiency in Microsoft Word is a skill that is necessary for today’s digital age. Microsoft Word software comes with a vast number of features to improve … Read more

How to use Google Sheets for Project Management

How to use Google Sheets for Project Management

There are many Project Management Tools available in the market. Many of them have cloud versions that you can access with a monthly subscription. If those subscription plans are not affordable to your project, this article is for you. In this post, I will show you how you can use Google Sheets for project management. … Read more

Free eBooks: Best Websites with a Collection of eBooks that can be Read or Downloaded for Free

Free eBooks - Best Websites with a Collection of eBooks

Are you looking for a good collection of free eBooks? There are some useful websites that have a good collection of eBooks that you can download or read them online. The following are the most popular websites for which you get free eBooks to read. These free ebook websites contain various types of categories, including … 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