Syntax
Patch(DataSource, BaseRecord, ChangeRecord1 [, ChangeRecord2, ...])Parameters
DataSource- The table or list to change.
BaseRecord- The record to update, or Defaults(DataSource) to create one.
ChangeRecord- The columns and values to set.
Examples
=Patch({Name: "Ada", Score: 70}, {Score: 95}){Name: "Ada", Score: 95}
Maker notes
- Returns the saved record, so you can store it with Set to get generated IDs.