20190708-PR-en-v1111-auto-append-to-google-sheets.pdf
Kyoto, Japan – July 8th, 2019 – Questetra, Inc., the global SaaS provider of Business Process Management (BPM), today announced that they have published the new version 11.11 of the Cloud-based Workflow product «Questetra BPM Suite» on Jul. 8th, 2019. This new version introduces a mechanism of automatically appending rows to a Google Sheets using only the standard features.
In daily work, various systems and services besides Workflow systems are used within the organization for the purpose of sales support, file storage/sharing, communication, collaboration, etc. In order to improve the convenience and productivity of users, it is essential to automate data coordination and processing among these multiple services.
Up to now «Questetra BPM Suite» has been capable of passing and receiving data in cooperation with external services by setting up HTTP communication or importing packaged «Add-ons» for communication processing, but knowledge of APIs and preparations in advance were required for them. In v11.11 a Service Task that performs the function has been added. By using the Service Task you will be able to build a system such as an «Order acceptance flow», for example, in which data concerning an order is automatically added to a Google Sheets right after the approval Step is processed, without the need for any extra programming.
Questetra BPM Suite
Cloud-based Workflow «Questetra BPM Suite» is a business platform for realizing paperless environments and remote-working.
Business issues are controlled according to a Business Flow Diagram. When a Process reaches a Human Task, the user will be asked to add their input. Also, when an issue reaches an automated Step the predetermined processing (server-side processing) such as “Generate PDF” and “Save to cloud storage” is performed automatically. (BPM: Business Process Management)
You can apply it to various business operations such as “Approval request flow”, “Document translation flow”, Quality check process, “Invoice issuance process”. Process owners of each Business Process can practice “improvement of Business Process” little by little in daily work. (Examples of Business Flow Diagram: https://en.workflow-sample.net/ )
Google Sheets: Append New Row
It will be able to automatically append data to Google Sheets using the Service Task. When you are using Google Sheets for aggregating sales or expenses, you can connect them with your business. Thus, you can reduce the work time spent on the administration of this process.
Other Improvements
Google Sheets: Download Choice Data
It allows you to collectively retrieve various master data (i.e. Customer master, Product master, etc.) automatically using the Service Task. The retrieved data can be used as options in the Select type Data Item.
Converter (Date to Japanese era string)
Using the Service Task, Date type and Datetime type data can be converted to a string of Japanese calendar date format. (e.g. Converts a value of Date type Data «2019-07-08» to «令和元年７月８日»)
Google Drive: Folder Search
This Service Task allows you to search for folders on Google Drive. It can be used incorporated in processing such as to store files to a folder that are found in a search.
