Record.RemoveFields

Syntax

Record.RemoveFields(
    record as record,
    fields as any,
    optional missingField as nullable number
) as record

About

Returns a record that removes all the fields specified in list fields from the input record. If the field specified does not exist, an error is raised.

Example 1

Remove the field "Price" from the record.

Usage

Record.RemoveFields([CustomerID = 1, Item = "Fishing rod", Price = 18.00], "Price")

Output

[CustomerID = 1, Item = "Fishing rod"]

Example 2

Remove the fields "Price" and "Item" from the record.

Usage

Record.RemoveFields([CustomerID = 1, Item = "Fishing rod", Price = 18.00], {"Price", "Item"})

Output

[CustomerID = 1]