Table Update Row Compound

This block updates rows in a data table that match several conditions at once.

It works like the Table Update Row block, but the row to update is selected with a list of Query Terms that must all match.

Configuration

• Table: the table to update.
• Query Terms: the conditions selecting the row to update. Each term has a Field Name, an Operator (Equals, Not Equal, Greater Than, Greater Than Equal To, Less Than, Less Than Equal To) and a Value.
• Fields: the fields to write, and the value to write to each. Static values, variables, and settings are acceptable as values.

Fields that are not listed under Fields keep their existing values.

For more information on how to use Data Tables, check out these docs.

See also Table Update Row, Table Lookup Compound