When it comes to mass data entry works, it is very essential to use data entry forms in order to improve accuracy and speed. If you use google sheets there are are many advantages compared to stand alone data entry forms like in MS Access. The default form option comes with the Google sheet (Google … Read more
Portable Document Format (PDF) is a file format used to present and exchange documents reliably, independent of software, hardware, or operating system. Invented by Adobe, PDF is now an open standard maintained by the International Organization for Standardization (ISO). PDFs can contain links and buttons, form fields, audio, video, and business logic. They can also … Read more
The drop-down lists are useful when you are creating data entry forms or creating interactive dashboards to present your data. While creating drop-down lists, you may come across situations where one drop-down list need to be populated dynamically as the value of the other drop-down changed. In other words, needs to create dependent drop-down lists. … Read more
The size of the images that can be printed/ captured from Google Map is limited to the dimensions of the browser window. In my previous post “How to capture, print a large Google map – larger than the screen” I explained to you how you can save large images. However, the size of the images … Read more
In the previous post, I have shown you how you can create your own map using Google My Maps. In that map, I developed a data table for that particual layer while creating the map. Sometimes you may need to export this data table to spreadsheets to use for other purposes. At present, Google My … Read more
With Google sheet app script, (similar to MS Excel VBA) you can extend the functionalities of the Google Sheet. In addition to that, you can automate some tasks using Triggers. In this post, I’m using Time-driven-triggers to automatically run an app script to get Google Map direction data to Google Sheet. How to get Google … Read more
Google Chrome is the most popular web browser across all platforms. According to statistics, it has more than a half of the market share. You can customize the browsing experience with extensions. There are some extensions that really improve your productivity depending on the way you surf the internet. Also, the Google Chrome itself has … Read more
Google is the most popular search engine in the world. However, did you know that there are special characters and words that you can include in your search to get even better results? Try following tricks on your next google search to get more accurate results. 01. Use quotes (“”) to search for an exact … Read more
When you are working with a set of a related data set, the easiest way to manage and analyze them is to use the table feature. By using Excel tables, you can manage data in the table rows and columns independently from the data on the outside of the table on the worksheet. You may … Read more