Field overview

This section will guide you through the various fields available in Baserow so that you can get the most out of them. Baserow fields can be customized to fit the specific needs of your project and is a powerful tool for creating robust, interconnected databases that can streamline your workflow and improve your productivity.

Each table in a database consists of numerous table cells, which are important snippets of information. These table cells are arranged into columns and rows. The rows are the records. This is where information for a certain object (i.e. customer, order, etc.) is kept. The columns are the fields. The field will correspond to certain data like ID, colour and postcode.

What is a field?

A table consists of rows and fields (columns). The rows and fields, also known as columns, are visible in the grid view. In a table, a field is a collection of values of the same data type. Each field is a data structure that holds a defined data type.

Fields are used to maintain table relationships. You can take a field from one table and incorporate it into any other table. That’s because a table is not just a way to store your data, it’s an object that can contain other objects, each one capable of collecting data.

enter image description here

In Baserow, each field can be configured to fit your use case. You can sort, filter, and hide the columns in a particular view without affecting other views in the table.

Working with field types

A field can store lots of different types of data, but importantly it can only store one type of information and not a mix. Fields have different data types, such as text, numbers, dates, boolean, collaborators, select and URL:

Field type Description
Single line text A single line text field is a type of field that allows you to input short and unique pieces of text into your table.
Long text A long text field can contain long paragraphs or multiple lines of text.
Link to table A link to table field creates a link between two existing tables by connecting data across tables with linked rows.
Number The number field is a field type that holds numerical values.
Rating A rating field is used to rate your rows in order to rank or evaluate their quality.
Boolean The boolean field represents information in a binary true/false format.
Date A date field lets you enter or update a date and a time into a cell.
Last modified The last modified field type returns the most recent date and time that a row was modified.
Created on The created on field type will automatically show the date and time that a row was created by a user.
URL The URL field holds a single URL.
Email An email field is a type of field that allows input of a single email address in a cell in the right format. When you click on an email address inside of an email field, your computer’s default email client will launch with the clicked email’s To: address in the To: field.
File A file field allows you to easily upload one or more files from your device or from a URL.
Single select The single select field type is a field type containing defined options to choose only one option from a set of options.
Multiple select A multiple select field contains a list of tags to choose multiple options from a set of options.
Phone number The phone number field will format a string of numbers as a phone number, in the form (XXX) XXX-XXXX.
Formula A value in each row can be calculated using a formula based on values in cells in the same row.
Lookup You can look for a specific field in a linked row using a lookup field.
Collaborator Assign collaborators by selecting names from a list of workspace members.

Computed fields

One of the most exciting features of Baserow is fields (columns) which are computed, updated, and displayed automatically. There are several types of computed fields in your table that rely on other rows or actions by users to develop the field’s value, like link to table, lookup, last modified, formula and created on fields.

You set up computed fields so that they relate to other fields rather than other cells so that they apply to every row of the table and use the same computation for each row.

As a relational database, Baserow enables users to link data across tables throughout a database with fields like link to table and lookup fields. You can create a field in a table, then use the link to table field in another table you’ve created as a quick way to bring new data into that table.

enter image description here

If you would like to know more about using fields in a database, then you can find out more in this article.

Still need help? If you’re looking for something else, please feel free to make recommendations or ask us questions—we’re ready to assist you.

   Ask the Baserow community

   Contact support for questions about Baserow or help with your account.