Skip to main content

Supported field types

Rowy supports over 30 field types. The data types match the types supported by Firestore.

Text

NameDescriptionData Type
Short TextText displayed on a single line.string
Long TextText displayed on multiple lines.string
Rich TextHTML edited with a rich text editor.string
EmailEmail address. Not validated.string
PhonePhone number stored as text. Not validated.string
URLWeb address. Not validated.string

Select

NameDescriptionData Type
Single SelectSingle value from predefined options. Options are searchable and users can optionally input custom values.string | null
Multi SelectMultiple values from predefined options. Options are searchable and users can optionally input custom values.string[]

Numeric

NameDescriptionData Type
NumberNumeric value.number
ToggleTrue/false value. Default: false.boolean
PercentagePercentage stored as a number between 0 and 1.number
RatingRating displayed as stars. Max stars is configurable, default: 5 stars.number
SliderNumeric value edited with a Slider. Range is configurable.number
ColorColor stored as Hex, RGB, and HSV. Edited with a visual picker.Color

Date & Time

NameDescriptionData Type
DateFormatted date. Format is configurable, default: yyyy-MM-dd. Edited with a visual picker.Timestamp
Date & TimeFormatted date & time. Format is configurable, default: yyyy-MM-dd HH:mm. Edited with a visual picker.Timestamp
Duration
(Alpha)
Duration calculated from two timestamps.{
  start: Timestamp,
  end: Timestamp
}

File

NameDescriptionData Type
ImageImage file uploaded to Firebase Storage. Supports JPEG, PNG, SVG, GIF, WebP, AVIF, JPEG XL.{
  downloadURL: string;
  lastModifiedTS: number;
  name: string;
  ref: string;
  type: string;
}[]
FileFile uploaded to Firebase Storage. Supports any file type.{
  downloadURL: string;
  lastModifiedTS: number;
  name: string;
  ref: string;
  type: string;
}[]

Connection

NameDescriptionData Type
Sub-TableConnects to a sub-table in the current row. Also displays number of rows inside the sub-table. Max sub-table depth: 100.N/A. No data is stored in the document field.
Connect Table
(Alpha)
Connects to an existing table to fetch a snapshot of values from a row. Requires Algolia setup. See guide{
  docPath: string;
  snapshot:
    Record<string, any>;
}[]
Connect Service
(Alpha)
Connects to an external web service to fetch a list of results.{
  docPath: string;
  snapshot:
    Record<string, any>;
}[]

Code

NameDescriptionData Type
JSONObject edited with a visual JSON editor.object
CodeRaw code edited with the Monaco Editor.string

Cloud Function

NameDescriptionData Type
ActionButton with pre-defined action script or triggers a Cloud Function. Optionally supports Undo and Redo.any
DerivativeValue derived from the rest of the row’s values. Displayed using any other field type. Requires Cloud Function setup. See guideany
AggregateValue aggregated from a specified sub-table of the row. Displayed using any other field type. Requires Cloud Function setup.any
StatusDisplays field value as custom status text. Read-only.any

Audit

Audit fields are automatically written when users create or update rows and auditing is enabled in the table.

By default, auditing is enabled and the fields are _createdBy and _updatedBy. The Created At and Updated At fields access _createdBy.timestamp and _updatedBy.timestamp respectively.

NameDescriptionData Type
Created ByDisplays the user that created the row and timestamp. Read-only.{
  displayName: string;
  email: string;
  emailVerified: boolean;
  isAnonymous: boolean;
  photoURL: string;
  uid: string;
  timestamp: Timestamp;
}
Updated ByDisplays the user that last updated the row, timestamp, and updated field key. Read-only.{
  displayName: string;
  email: string;
  emailVerified: boolean;
  isAnonymous: boolean;
  photoURL: string;
  uid: string;
  timestamp: Timestamp;
  updatedField?: string;
}
Created AtDisplays the timestamp of when the row was created. Read-only.Timestamp
Updated AtDisplays the timestamp of the last update to the row. Read-only.Timestamp

Metadata

NameDescriptionData Type
UserUser information and optionally, timestamp. Read-only.{
  displayName: string;
  email: string;
  emailVerified: boolean;
  isAnonymous: boolean;
  photoURL: string;
  uid: string;
  timestamp?: Timestamp;
}
IDDisplays the row’s ID. Read-only. Cannot be sorted.string