Columns
Last updated
Last updated
Tables consist of columns and rows. Columns are created in different types according to the type of information held in the row. For example, the product name and description are of text type, while the product image column is of image type.
There are different types of columns that define the type of data you put in.
Field type name
Data type
Description
Text
string
The single line text field is best for short, unique pieces of text, such as the names of your friends, the names of your cats, or the names of your friends' cats.
Long text
string
A long text field is great when you need to keep notes or multiple lines of text in each record.
Integer
integer
The Integer field type is a field type designed to hold integer numbers. The Integer field type is a general-purpose field type for most numerical values.
Decimal
decimal
The Decimal field type is a field type designed to hold decimal numbers.
Checkbox
boolean
A checkbox field is useful for true/false values within a record.
Date
string (ISO 8601 formatted date)
A date field allows you to easily enter a date into a cell.
Date & Time
string (ISO 8601 formatted date)
A Datetime field allows you to easily enter a date & time into a cell.
File
File
A file field is a type of field that allows you to attach one file within a record.
Image
Image
An image field is a type of field that allows you to attach one image within a record.
string
An email field is intended to store a single email address in each cell.
Phone number
string
A phone number field will format a 10-digit string of numbers as a US/Canada phone number, in the form (XXX) XXX-XXXX.
URL
string
A URL field is intended to store a single URL in each cell. Clicking on a URL will bring you to that URL.
GeoLocation
string
A GeoLocation field is intended to store a coordinate (latitude & longitude) in each cell.
Relation (Link to another record)
array of record IDs (strings)
Relation field allows you to represent the relationships between related rows by creating links between them. This is particularly helpful when you have multiple tables of related items or concepts. For example, if you have a table of contacts and a table of companies, you can use a relation field to link each contact to the company that they work for.
Lookup
array of numbers, strings, booleans, or objects
A lookup field allows you to look up a specific field in a relation.
Created
string (ISO 8601 formatted date)
The created time field type will automatically show the date (and optionally, time) that a record was created.
Created By
collaborator object
The created by field will automatically show which collaborator created a record within the base.
Modified
string (ISO 8601 formatted date)
The last modified time field type returns the most recent date and time that a record was modified by a user in a non-computed field
ModifiedBy
collaborator object
The last modified by field displays which collaborator made the most recent change to a record.