Record.FieldOrDefault

Syntax

Record.FieldOrDefault(record as nullable record, field as text, optional defaultValue as any) as any

About

Returns the value of the specified field field in the record record. If the field is not found, the optional defaultValue is returned.

Example 1

Find the value of field "Phone" in the record, or return null if it doesn't exist.

Record.FieldOrDefault([CustomerID =1, Name="Bob"], "Phone")

null

Example 2

Find the value of field "Phone" in the record, or return the default if it doesn't exist.

Record.FieldOrDefault([CustomerID =1, Name="Bob"], "Phone", "123-4567")

"123-4567"