Date, Calc after N Business Days
Calculates N business days after the specified date. If N is negative, returns N business days ago. It is necessary to set a holiday in advance. It is also possible to add company-original holidays.
Routine Report
Date, Determine Whether Business Day
Determines whether the date value is Business Day or not. If holiday, returns the name of holiday. If Sat or Sun, returns the day name. Otherwise, returns an empty string. You can also set special holidays set by your company.
TSV String, Create Cross Table of Count
Aggregates the count of data by 2 aggregation-key columns: Pivot table. Count and Percentage are tabulated as a cross table TSV. Eg, Survey Results TSV is automatically generated from Survey Records TSV. 2D frequency distribution.
TSV String, Create Summary Table of Count
Aggregates the count of data by aggregation-keys. Count and Percentage are tabulated as a summary table TSV. Eg, Survey Results TSV is automatically generated from Survey Records TSV. Frequency distribution.
TSV String, Create Cross Table for Numeric Column
Aggregates the values in a numeric column by 2 aggregation-key columns: Pivot table. Sum, Percentage, Count and Average are tabulated as a cross table TSV. Eg, “Sales for each combination of Client-Y and Store-X” is aggregated from “Sales log TSV”.
TSV String, Create Summary Table for Numeric Column
Aggregates the values in a numeric column by aggregation-keys. Sum, Percentage, Count and Average are tabulated as a summary table TSV. For example, “Sales for each client” is aggregated from “Sales log TSV”. Grand Total Tabulation.
TSV String, Calc Changes in Two Numeric Columns
Calculates the difference and rate of change for the two numeric columns in the TSV. Adds the calculated value to the rightmost column. It realizes month-on-month and year-on-year automation.
Two TSV Strings, Join on Common Column
Merges two TSVs based on a common key-field. Keeps all the rows from TsvA (left table) and brings in any matching rows from TsvB (right table); Left Outer Join. Neither TSV needs to be sorted. Only the upper row in TsvB will be matched.
Google Fit: FitnessData, Get Steps
Gets the step count data in Google Fit. Gets the aggregated value for any period. It is also possible to acquire travel distance data (meters). For example, the number of steps taken during working hours for care workers and delivery staff is acquired.
Daily report flow-weather record (Add-on)
Store Manager submits a daily report to the area manager to be checked at the [2. Report Check/Comment] Step. Automatically retrieves the day’s weather data via API and records it.
Daily report flow-weather record (Script Task)
Submits a daily report to the supervisor to be checked at [2. Report Check/Comment] Step. Automatically retrieves weather data of the day via API and records it.
BPO Shipment Process
Receive product delivery information, pack and ship. It is automatically started when delivery information is received from the consignor via HTTP communication. An invoice is automatically generated, and when the [1. Packing completion] process is completed, “Packing complete” is reported to the consignor’s business process. If “inspection” is instructed as an option, an inspection is performed and a completion report is given.
Progress Report Process
Multiple people will report and summarize the progress of the project. Reporters appointed at the [1. Rapporteur Designation] Step make a report and handle the [2. Progress in Subjective]. With the aggregation of reported values will help to increase the reliability of progress evaluation.
Translation Request Flow
Requests for translation of a draft. The sentences entered in [1. Document set] will be delivered to the translator. When the translation is completed (2. translation), the number of characters is recorded and the requester is notified.
Order Report Flow
To be approved by the Sales Manager. Sales team leader makes [2. Confirmation], and then Sales Manager makes [3. Approval]. If the order value is over 1 million JPY, it will be also reported to the directors.
Order Report Process
To be approved by the Sales Manager. Sales team leader makes [2. Confirmation], and then Sales Manager makes [3. Approval]. If the order value is over 1 million JPY, it will be also reported to the directors. Assumed to be invoked from Quotation Approval Process, etc.
Personnel Change Announcement Process
Notifies Personnel changes information to in-house by email. Starts automatically every Friday early in the morning and automatically and retrieves events concerning HR scheduled for the following week from Google Calendar. If there is an HR event, it will be sent to the internal mailing list.
Google Fit: Dataset; Aggregate Step Count
Aggregates data of Step Count and Distance (meters) in Google Fit. Multiple data sets from multiple sources (including manual input) can be aggregated. Note that the results of simultaneous measurement with multiple devices are all added up.
Fax Reception Process
Internet FAX (cloud fax service) is a mechanism to convert received faxes into PDFs and notify them by e-mail. This Workflow-App receives the notification email via mailing list. After that, PDF data received is checked in [1. Confirm order]. Noise data such as unwanted faxes and false positives are eliminated. The files are saved according to the rule in the automatic processing step [Save G Drive].
Guest Complaints Sharing Process
If there is a complaint from the guest, it will be recorded in [0. Entr. Guest / Complaint]. The front representative can recognize the occurrence of complaints by automatic mail at 5 o’clock in the morning. The content to be shared by the cleaning staff from the front manager is entered in [1. Rprt. Checked-out].