In this tutorial, we’ll explore user authentication in Google Apps Script web apps. The system will use Google Account authentication and verify users against a list of authorized Gmail addresses stored in a Google Sheet. This setup ensures that only users with specific email addresses can access the web app, demonstrating an effective approach to … Read more
In our blog, we have published several tutorials on creating web apps with data entry forms using Google Apps Script. Data entry forms significantly enhance the accuracy and speed of your data entry tasks. When creating these forms, you have several options for dropdown lists: hardcoding the items directly into your code or populating them … Read more
In this blog, we have discussed several methods that you can use to create Google Maps from Google Sheets data. In this post, let’s see how we can generate Google Maps in Google Sheets. In this post, I am going to use Google Apps Script to create the map image inside the Google Sheets. You … Read more
We identify each cell in the spreadsheet by a combination of its column letter and row number. A range of cells is defined using the upper Left cell and the lower Right cell. We call this A1 notation. But writing a complex formula using A1 notation is a bit difficult to understand and maintain. You … Read more
A checklist is a list of things that can be checked off individually when completed or noted. In a checklist, there is a checkbox for each list item that you can check or uncheck. This post will show you how to make a checklist in Google Docs. You may also be interested in How to … Read more
In the previous tutorial, we discussed how to import data from another Sheet in the same Google Spreadsheet. This tutorial will show you how to import data from one Google Sheet to another. And also, you can use this method to import data from multiple Google Spreadsheets. How to uniquely identify each Google Spreadsheet You … Read more
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
An Index is a list of terms and topics that are discussed in a document. The terms and topics are listed along with the page numbers that they appear in the document. In this post, I will show you how easily you can create an Index in Microsoft Word. To create an Index first, you … Read more
When you add several tables and figures or any other objects in your report, it is a best practice to create a list of tables and figures or lists of other objects in the report’s preface. In academic writing, this is a must-have section of your report. Like the table of contents, you can also … Read more
Table of content help readers to easily navigate through your document. In this post, I will show you how to create a table of contents in Microsoft Word. Steps to create a Table of Contents To create a Table of Contents in Microsoft Word, you need to prepare your document by applying built-in heading styles … Read more