An easy way to deal with Google Apps Script’s 6-minute limit

About the 6-minute limit Google Apps Script is handy, and it will help you a lot in your work. However, as you use it, you may hit a big wall. That is the six-minute limit on execution time. As the official documentation states, the maximum allowed time per execution of Google Apps Script is 6Continue reading “An easy way to deal with Google Apps Script’s 6-minute limit”

How can older people use Google Drive and Google Sheets mobile apps well?

Google Drive and Google Sheets are fantastic apps for small businesses and non-profit organizations because these apps give us the benefits of sharing storage and accessing databases concurrently from each remote location, and most importantly, they are free! For ordinary users, it is not difficult to use these apps, but what about older people? IContinue reading “How can older people use Google Drive and Google Sheets mobile apps well?”

Tips: How to create a drop-down list that excludes values that have already been entered

Google Sheets has a useful feature called “Data Validation” that limits user input to acceptable limits. If you set its “Criteria” to “List from a range,” the target cells will show a drop-down list that lists up the values that are included in the range you set. However, sometimes you might want to restrict theContinue reading “Tips: How to create a drop-down list that excludes values that have already been entered”

Flutter state management for purists

State management was an obvious thing. “Do your own work. No one’s going to do it for you.” Have you ever been taught something like this? I always thought that this was a given, especially in the programming world.In particular, think about the “state management” ( people use this word as managing data that shouldContinue reading “Flutter state management for purists”

How to move to the last selected row when you open Google Sheets.

Google Sheets is versatile. I use it for data storage, programming, and also for writing my work journals. When you use it as a work journal, you will usually freeze the sheet’s top part since the header will be hidden if there are many records. Like this; However, the more records you have, the moreContinue reading “How to move to the last selected row when you open Google Sheets.”

GAS-Terminal: Environment for smart execution of Google Apps Script

Running GAS is a pain. Do you like Google Apps Script(GAS)? Me too! 👍I’ve written a lot of GASs to run system processes and maintain data. Most of them are run by various triggers automatically, but sometimes I need to run some scripts by hand. Then I’ll be reminded that “Running GAS is a pain!”Continue reading “GAS-Terminal: Environment for smart execution of Google Apps Script”

Flutter Web: Use IndexedDB as File Storage

A simple technique when you migrate from mobile to Web. Flutter is one of the greatest solutions to publish apps to multiple platforms. When you want to migrate Flutter for mobile to Flutter for Web, you typically only need to make a few changes.But if you use local file storage on Flutter for mobile, thereContinue reading “Flutter Web: Use IndexedDB as File Storage”

6 Reasons Why Small Business IT Staff Should Switch from Excel to Google Sheets — Part2

A feeling of an IT staff in a small team If you are an IT staff in a small business, maybe you’ve already been considering what software you should use for document management as well as I did. In many companies that normally use Windows PCs, the employees, especially IT staff, use Microsoft Excel. SinceContinue reading “6 Reasons Why Small Business IT Staff Should Switch from Excel to Google Sheets — Part2”

6 Reasons Why Small Business IT Staff Should Switch from Excel to Google Sheets — Part1

A feeling of an IT staff in a small team If you are an IT staff in a small business, maybe you’ve already been considering what software you should use for document management as well as I did.  In many companies that normally use Windows PCs, the employees, especially IT staff, use Microsoft Excel. SinceContinue reading “6 Reasons Why Small Business IT Staff Should Switch from Excel to Google Sheets — Part1”

Why My Medium Stories are not Searchable by Google?

The wonder of robots meta tags added to stories I expected increasing traffic. Introduction I’m a beginner of Medium story writer. I’ve posted about two articles recently. Since it was my first experience posting blog stories, I have watched the number of accesses increase with excitement. In the beginning, there are some accesses to theContinue reading “Why My Medium Stories are not Searchable by Google?”

Create your website with WordPress.com
Get started