Episode 493: Managing Uses of Team Password (Sheets API v4)

Day-to-day work is full of Team passwords...

When you install a wifi router, you configure "Admin password". When you apply for online printing service, you register a "Business account". When you just buy a scanner, you are demanded "User registration". Despite I have grown up having been taught "Never share your password" since my childhood, there are lots of passwords that are inevitable to share in the real adult life! (And, top secret files are stored in the file server of the company...)


The following Workflow is a Business Process for managing "Team password".

You may regard it as a "Password manager" of an organization. It is devised to disclose a password after ten minutes when an employee makes a request. All the information, such as When it was used, Who used it, and Which password, will be recorded. (Moreover, "Password change" by the administrator will be recorded, as well.)

[Password Request]

Episode 492: Referring to Client Master SpreadSheet (Sheets API v4)

In many companies, "Client lists" are managed with spreadsheet software.

And I just think that "Google SpreadSheet" and "kintone", which are Cloud-based database, are utilized more and more now, comparing to 10 years ago when "Excel files" had been created as a matter of course. After all, at a reasonable price (or even for Free), you can enjoy the benefit of convenience,such as

• Accessible from anywhere at any time
• Minimize the risk of data lost
• No need to duplicate data to carry
• Access logs are preservable depending on the service plan

It would be grateful especially for the small and medium-sized and micro enterprises.

[API communication]

Moreover, you will be able to build a mechanism which an external system to refer a "Client list", using Cloud-based database. (API function: Application Programming Interface)

The following Workflow is an automated flow for retrieving a "Client list on Google SpreadSheet" into Workflow platform. In this example, "Client list" will be automatically synchronized every night at one o'clock. (The flow itself is almost the same as Synchronization with kintone which I introduced previously.)

[Client master Synchronization - SpreadSheet Integration]

Episode 491: Bank CSV Data into Google SpreadSheet

"Are you transcribing the banking logs?"

Every bank in Japan give you a booklet referred to "Passbook". When you insert it into an ATM, all the records of deposit and withdrawal will be printed on it fine and clear. However, as long as the "Passbook" is a paper booklet, people who are accessible to the information in it are limited. Yet, it is cumbersome to enter the data into "Bank book.xis" manually.

The following Business flow is an operation of exporting account activity to Google SpreadSheet.

It is a mechanism that automatically appending to specified SpreadSheet when importing "Account activity" which can be obtained through online service provided by the bank. In this example, a Script has been set to retrieve a tab delimited file in a format referred as "ANSER-API" which is widely used in Japanese Banks.

I would call this as "Online Passbook"... Isn't it convenient?

[Activity Log Registration]

Episode 490: Placing a Button for Automatic Password Generation

"Too many input fields!"

Dissatisfactions for a Workflow system, many of them are "labor for data input". However, it tends to increase the number of data which is "inevitable to input", for continuing Business Process improvement. Then...

It might seem surprising, but the most efficient burden reduction measures is "to enable to Click-input for some common data". Although nothing is better than to experience actually, the work efficiency becomes very good if one click entry was possible even for five or ten letters. And you will feel so good, if you can input one after another to a lot of input forms that have placed in a row.

The following sample is an altered version of "Button input", which I introduced to you previously, by adding "a button for automatic generation and input of a password". By arranging such a button, you will be able to correspond to a work such as, for example, "issuing a system account" with concentrating.

Reference) Episode 481: Devising of "Button Input" to Input Form

[Test flow for Input Form 2]