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 …