Record.FieldOrDefault

About

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

Syntax

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

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"