Record Functions

Record.Combine

Syntax Record.Combine(records as list) as record Description Combines the records in the given records. If …

Record.HasFields

Syntax Record.HasFields(record as record, fields as any) as logical Description Indicates whether the record record …

Record.TransformFields

Syntax Record.TransformFields(record as record, transformOperations as list, optional missingField as nullable number) as record Description …

Record.FieldCount

Syntax Record.FieldCount(record as record) as number Description Returns the number of fields in the record …

Record.RemoveFields

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

Record.AddField

Syntax Record.AddField(record as record, fieldName as text, value as any, optional delayed as nullable logical) …

Record.SelectFields

Syntax Record.SelectFields(record as record, fields as any, optional missingField as nullable number) as record Description …

Record.ReorderFields

Syntax Record.ReorderFields(record as record, fieldOrder as list, optional missingField as nullable number) as record Description …

Record.ToList

Syntax Record.ToList(record as record) as list Description Returns a list of values containing the field …

Record.Field

Syntax Record.Field(record as record, field as text) as any Description Returns the value of the …

Record.RenameFields

Syntax Record.RenameFields(record as record, renames as list, optional missingField as nullable number) as record Description …

Record.FieldValues

Syntax Record.FieldValues(record as record) as list Description Returns a list of the field values in …

Record.ToTable

Syntax Record.ToTable(record as record) as table Description Returns a table containing the columns Name and …

Record.FromTable

Syntax Record.FromTable(table as table) as record Description Returns a record from a table of records …

Record.FieldNames

Syntax Record.FieldNames(record as record) as list Description Returns the names of the fields in the …

Record.FieldOrDefault

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

Record.FromList

Syntax Record.FromList(list as list, fields as any) as record Description Returns a record given a …