M227: Auto Executing Data Binding, Arithmetic Operations

By placing [Service Task (Data Assignment)] in the middle of a Workflow, you can overwrite Business data upon each Issue passing the Step. You can achieve an automatic set of "current time (Time of passing)" or set of 'Tax price" which has referred to "Price excluding Tax" that entered at upstream Step.

1. Usage Example of Data Auto-setting

1. Calculation of the relative value

To set the date of three days later from "document delivery date" which has been entered in the upstream process, as the "deadline"

2. Unified Format

Automatically generates a string in accordance with the naming convention and set it as "invoice ID"

• If you want to automate more complex data processing, you can use the [Script Task]

2. Setting a Formula for Calculation of the Numerical Value

a. Reference to Other Numerical Data

Calculating the numerical value by referring to Numeric type data or fixed real number

( (data['1'] + data['2']) * 0.05 - data['3'].summary['1'] ) / 30

R2270: Automatic Assignment of Numerical (Data Assignment Format)

3. Setting a Formula for Processing of Date Time

a. Reference to Other Datetime Data

Calculating the date or date time by referring to the Date type data or Datetime type data

b. Reference to Management information of Workflow Platform

Calculation by referring to the Start time or the current time

data['9'].addHours(9)

#now.addDays(1).getFirstTimeInDate().addHours(9)

R2271: Automatic Assignment of Datetime (Data Assignment Format)

4. Set the Selection Result

a. Set a Fixed value

Set the Options ID fixedly into Select type data

R2273: Automatic Assignment of Choice (Data setting formula)

5. Setting a Formula for Generation of String

a. Reference to Other Business data

Generate a string from such as String type data or User type data

b. Reference to Management information of Workflow Platform

Generate strings from such as the name of the Business operation or the Started User

Mr. #{data['8']}

xyz-#{#format(data['4'], 'yyyyMMdd')}

R2272: Automatic Assignment of String (Data Assignment Format)

---

X. Workflow-Sample

• 2017-11-20 (Expense Report flow-Input Check): Episode 562: Reason for Not Using Cloud Expense Management System (4)
• 2017-11-13 (Expense Report flow-Spreadsheet): Episode 561: Reason for Not Using Cloud Expense Management System (3)
• 2017-11-06 (Expense Report flow-Status Control): Episode 560: Reason for Not Using Cloud Expense Management System (2)
• 2017-05-29 (Base flow of Request type process-Script): Episode 537: Visualizing the Status of Occurrence of Redoing Work
• 2017-05-22 (Base flow of Request type process): Episode 536: The Number of Times of Sending-Back is also Valuable Issue Data!
• 2017-04-17 (Keyword Search on TV Listing): Episode 531: Automatic Search on TV Listings
• 2016-11-07 (Customer Master Appending): Episode 508: Officialize Corporate Names in "Customer Master" by Corporate Number API
• 2016-09-20 (Approval Request flow - Record to Spreadsheet): Episode 501: You Don't Know the Spending of Budget?
• 2016-05-30 (Catalogue Request Response): Episode 485: Auto-addition to "Catalogue Mailing List"
• 2016-05-23 (Credit Management): Episode 484: Addition of New Client via kintone API
• 2016-02-29 (Attendance Report flow): Episode 472: Detect Signs of Flu in Business System?
• 2016-02-22 (Approval Request): Episode 471: I won't Give an Approval to My Own Application! (by a director of a department)
• 2016-01-12 (Attendance Report flow): Episode 465: Attendance Management in Cloud-based Workflow!
• 2016-01-04 (Out-of-pocket Expenses Claim): Episode 464: Out-of-pocket Expenses Reimbursement Claim (Starter Template)
• 2015-12-21 (Planning-Approval flow): Episode 462: Planning - Approval (Basic Business Pack)
• 2015-10-19 (Daily Sales Report flow (Geolocation)): GPS Recording in Daily Report Process
• 2015-10-13 (Inquiry Correspondence process): Complaint Management that Refers to Customer Master
• 2015-10-05 (Daily Sales Report flow): Daily Sales Report Referring to Customer Master Data
• 2015-09-28 (Quote Creation flow): Quote Creation Flow that Refers to Customer Master Data
• 2015-04-27: Cooperation of Invoicing Flow and Accounting System
• 2015-04-20: Centrally Management for the Quotation Data
• 2015-03-23: Visualization and Labor Saving on Appraisal of Competitive Quotes
• 2014-11-17: 'Timed Event' is Effective for Contract Renewal Process
• 2014-08-04: User Account Issuance Flow to Support the Internal Control
• 2014-07-14: Upstream Process of Entering the Client Name, the Template
• 2014-06-02: Trick for Eliminating Fluctuation from Client's Name
• 2014-04-14: "Contrivance to Save In-house Ideas" on Workflow
• 2014-01-27: Cloud-based Workflow and Google Calendar (OAuth 2.0 federation)
• 2013-03-11: Activity Report of Route Sales is a "Business Flow"! How to Write it? (Route Sales Report flow)