Update Field Values of Records in Data Table

Parameter Configuration

Parameter	Description
Data Table	The data table to query
Update Matching Records	Update records that meet the conditions. Condition values can be dynamically specified through expressions
Updater	The updater of the record. The updater can be dynamically specified through expressions
Validate Form Rules	When enabled, field rules set in the form will be validated when creating records
Record Changes	When enabled, field change records will be recorded when updating records
Skip Rollup Calculation	When enabled, the system will not trigger the refresh of rollup fields in this table after data insertion
Set Field Values	Set field values for updating records. Record field values can be dynamically specified through expressions

Notes

• Validate Form Rules: When enabled, form validation rules set in the form will be used to validate the form when creating records

• Skip Rollup Calculation: When enabled, the system will not trigger the refresh of rollup fields in this table after data insertion

  • Use automation step Update Lookup Rollup Field Value
  • Use script functions informat.table.refreshRelationRollup or informat.table.refreshLookupRollup

• Record Changes: By default, when records are updated through automation and scripts, the server does not automatically save record change information. If needed, enable this option

• Update Matching Records: If no filter is set, this step will update all records in the data table. Therefore, try to clearly define the data range to be updated

• For list-type fields such as Child Object, Related List, and Lookup List, you need to pass an array type. For example, if the data table structure displayed for the list type is as follows:

  | Field Identifier | Field Name | Field Type |
  |----------------|-----------|------------|
  | name           | Name      | Single Line Text |
  | age            | Age       | Number |
  
  The data structure that needs to be passed is:
  ```json
  [
      { "id":"0001", "name":"zhang san", "age":20 }, // Updated data
      { "name":"li si", "age":22 }, // Newly added data
      { "id":"0002", "$deleted":true } // Data to be deleted
  ]
  ```
  
  ::: info Example Explanation
  - If the `id` attribute is not set, it means the data is newly added.
  - If the `id` attribute has a value and `$deleted` is set to `true`, it means this data will be deleted.
  - If the `id` attribute has a value, it means this record will be updated. Fields not listed will not be updated.
  :::