Update Data

Overview

Update Data

Automatically updates Business Data with the specified value or the evaluation result of the formula. Capable of updating several Data Items also in one automatic Step.

Capture

Notes

• If Value or Expression is empty, the value of the Data Item will be cleared
• You can set assignment settings (updating of values) to multiple Data Items in one Step
• If you set multiple assignment settings those will be executed concurrently, so there is no order of updating
• Data Item references are inserted in Expression Language using Field Name
• Format of Automatic Assignment
  • R2270: Numeric Output via EL syntax
  • R2271: Output of Date and Datetime Data via EL syntax
  • R2272: Output of Strings via EL syntax
  • R2273: Auto-assignment to Select Type
  • R2274: Auto-assignment to User/Organization Type via EL Syntax
• Numerical information and date/time information can also be formatted and output as a format-specified character string using Formatter
• The expressions of Data items to be stored – Title, String-type, Select-type, Date-type, and Datetime-type – are along with the implement of SpEL (Spring Expression Language).
  • Title and String-type Data Item use “4.3.18. Expression templating“, which means the content of “#{}” is evaluated as SpEL.
  • For Select-type, the value of the update result is treated as the choice ID

Config Examples

• Automation Name: “j++”
  • Output Type: Numeric-Type
  • Expression: #q_intJ + 1
• Automation Name: “Total”
  • Output Type: Numeric-Type
  • Expression: #q_numSubtotal1 + #q_numSubtotal2
• Automation Name: “Last day of the previous month”
  • Output Type: Date-Type
  • Expression: #today.addMonths(-1).getLastDateInMonth()
• Automation Name: “(Numeric-type) days after”
  • Output Type: Date-Type
  • Expression: #today.addDays(#q_num.intValue())
• Automation Name: “Formatted Title”
  • Output Type: Title
  • Expression: HR: #{#q_employeeName}, #{#q_termOfEmployment}
• Automation Name: “Timestamp File Name”
  • Output Type: String-Type (Singleline)
  • Expression: invoice-#{processInstanceId}-#{#dateFormatter.format('yyyyMMddHHmm', #now)}.pdf
• Automation Name: “Email Draft”
  • Output Type: String-Type (Multiline)
  • Expression: Dear #{#q_customerName},<br>If you need to contact support, please include this reference: #{processInstanceId}<br>Best regards,
• Automation Name: “Copy Choice Result”
  • Output Type: Select-type
  • Expression: #q_otherSelect

See also

Let’s Calculate the Total Amount Automatically

Let’s Set the Title Automatically

open_in_new

M227: Auto Executing Data Binding, Arithmetic Operations