Columns

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.

Column Types

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.
Email	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.