This section will guide you through the various fields available in Baserow so that you can get the most out of them.
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.
A field can store lots of different types of data, but importantly it can only store one type of information and not a mix. Standard databases offer many different types of fields:
|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.|
|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.|
All fields on Baserow have customizations that are specific to that view. As a relational database, Baserow enables users to link data across tables throughout a database with fields like link to table and lookup fields.
To create a new field, you can click on the
+ button just after the last visible field at the end of the table. Next, select the field type and input a name to identify the field. Click ‘Create’.
To duplicate a field, click on the arrow down icon next to a field. Select the ‘Duplicate field’ option from the dropdown.
While duplicating a field, you can choose either to duplicate it with or without data. To duplicate a field, click on the arrow next to the field name, select the duplicate field option from the dropdown and put a checker mark if you want it to be duplicated together with data.
You can rearrange the order of the fields in your grid view by clicking and dragging the field header to move the fields.
You can also easily move a field directly by clicking and dragging a field in the enlarged view.
To edit a field,
You can create a new field using the values from an existing field. From the field customization menu, select a new field from the dropdown. This will convert the values in your existing field to the new field format.
Note that you cannot insert a new field from the Primary field.
To add a new field, you can either use the + button at the end of the table or insert a new field between existing fields. You can select a field and either insert a new field to the left or right of that field. Learn more about reordering and moving fields.
To insert a new field,
You can create and combine conditions to customize how rows are filtered, enabling you to build highly specific, organized views for your workflows.
To create a filter,
We advise reading this section on adding filters in a view first if you are new to creating conditions to filter your rows.
There are numerous ways to arrange distinct field types. Keep in mind that while sorting in ascending order, blank values nearly always appear at the top.
Fields can be sorted in ascending order (A → Z (or) 1 → 9 (or) ☑︎ → ☐) or descending order (Z → A (or) 9 → 1 (or) ☐ → ☑︎).
Text field types can be sorted alphabetically (A → Z) or in reverse alphabetical order (Z → A), including single line text, long text, email, multiple select, formula, URL, and single select fields.
Both ascending order 1 → 9 and descending order 9 → 1 can be used in numerical fields like number, rating, phone number, last modified, created on and date fields (from the earliest date to the latest date, or from the latest date to the earliest date).
You can either ☑︎ → ☐ in ascending order or ☐ → ☑︎ in descending order sort boolean fields according to whether the box has been checked or not.
To hide or show fields, click the ‘Hide fields’ button in the grid view or ‘Customize cards’ button kanban view to bring up the hide fields dialog.
Note that you cannot hide the Primary field.
By clicking the field header in grid view and choosing the Hide field option from the dropdown menu, you can also hide a field.
You also can hide or show specific fields within an expanded view by clicking the option menu beside the field.
Note that you cannot delete the Primary field.
To delete a field, other than the primary field, you can do it by selecting the ‘Delete field’ option from the dialog box beside the field’s name.
You can recover deleted things by using the ‘Trash.’ To review and restore any fields that have been deleted in a base during the last three days. Learn more on how to access the trash here.
If you would like to know more about using fields in a database, then you can find out more in this blog post.
If you’re looking for something else, please feel free to make recommendations or ask us questions in our online community —we’re ready to assist you!