Skip to content

Value & List Types

A row stores its value as a string. Two fields decide what it becomes in the built object: type (the scalar kind) and listType (single value or list).

type declares how the raw string is parsed. See the ValueType enum.

typeParses intoNotes
nullnull
stringstringUsed as-is.
booleanboolean"true"/"1"true.
numbernumberInteger or float.
integernumberBase-10 integer.
floatnumberFloating-point.
hexadecimalnumberHex string, with or without 0x. Invalid hex throws.
datetimeDateDate and time (RFC 2822 / ISO 8601).
datestringCalendar date with no time part (e.g. "2026-06-15"). Kept as the validated string; a value with a time, or an invalid date, throws.
timestringClock time HH:mm or HH:mm:ss (e.g. "14:30"). Kept as the validated string; out-of-range values like "90:77" throw.
regexpRegExp/pattern/flags or a plain pattern.
jsonanyJSON.parse (object, array, …).
anyinferredBest-effort auto-detection.

date and time are intentionally kept as validated strings, not Date objects — they carry no full timestamp. Use datetime when you need a Date.

A value that can’t be parsed to its declared type throws at construction.

A value is parsed to one value of its type"gemini" stays the string "gemini", "8080" (as integer) becomes the number 8080. You do not get a one-element array. Lists are opt-in via listType.

// type: 'integer', listType: 'none', value: '8080' → 8080 (a number)
// type: 'string', listType: 'none', value: 'gemini' → 'gemini'

listType controls whether a value is a single value or a list. See the ListType enum.

listTypeResultEmpty value →
noneA single parsed value of type.null (or "" for string).
arrayAn array of values, each parsed to type (the raw value is split on commas).[]
cslA normalized comma-separated string (whitespace around separators trimmed).""
// listType: 'array', type: 'integer', value: '1, 2, 3' → [1, 2, 3]
// listType: 'csl', type: 'string', value: 'a , b ,c' → 'a,b,c'

array and csl parse every comma-separated part to type, so a malformed part throws just like a malformed scalar.