Learn Baserow Basic Concepts

Ready to forge ahead? We want to help you get the most out of Baserow. Here is a cheat sheet of Baserow’s core concepts - group, database, table, views - that you need to get started with for your first project.

enter image description here

What is a Group?

Baserow groups are a top-level navigation item in the menu bar. Your groups are blank canvases on which you can add any database you want. You can join or create as many groups as you like, invite your teammates, and you can easily switch between them in the dashboard as need be.

On your Dashboard, click the ‘+ Create group’ button to add a new group.

enter image description here

What is a Database?

A database is a collection of tables, each containing rows and columns. A Baserow database can include multiple tables containing information for different projects.

Baserow databases are an important part of your workspace; they keep you organized and allow you to quickly view and update your data. You can easily create tables with related fields, like adding all the contact information from a list of clients.

Applications like databases belong to a group, so in order to create them, you need to create a group.

enter image description here

What is a Table?

In Baserow, databases are like file folders. They let you organize multiple tables into one central place. Tables make it easy to analyze and interpret your data. You can store multiple tables in a single database to outline a project or organize information.

You can group pieces of data that have some sort of commonality—for example, if you have the sales of different products in different regions. Tables allow you to customize a collection of data. A table contains data organized in columns (fields) and rows which can be customised by colours and filters.

enter image description here

Because each table resembles a spreadsheet, you have the option of editing or creating a new table within a database, each with its own set of fields. You’ll see a unique viewpoint of your work whether you’re looking at a grid, gallery, form, or kanban view.

Tip: Fully customize your table data with sorting, filtering, and your favourite view!

What is a View?

Changes made with traditional spreadsheets such as Microsoft Excel and Google Spreadsheets are made for all users. If you want to change the look of all the data, this change will be reflected in all the sheets.

In contrast to traditional databases, Baserow allows you to set up your information in various ways. You can choose to create different views of a table.

When you create a new table, the default view that’s shown when you open a table is called "Grid view”. So any time you’re looking at your data, you’re seeing it in a grid view. The table-like display you see here, with rows and columns of data, is called a grid view.

enter image description here

Users familiar with these traditional spreadsheets will find this interface familiar. A grid view organizes data into rows and columns, just like a spreadsheet. In a grid view, the first column is headers and the other columns are standard body text in rows and columns.

Baserow tables are more than just grids. In addition to the default grid view, each table can be shown in many different ways, and you decide which view is the most useful. You can visualize their contents in many different ways, such as a form, kanban or gallery.

Here is an example of a kanban view:

enter image description here

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 in a view is a data structure that holds a defined data type. Fields have different data types, such as text, numbers, dates, boolean, collaborators, select and URL. You can sort, filter, and hide the columns in a particular view without affecting other views in the table.

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

What are Rows and Cells?

Each default table in Baserow is organized into a grid of rows, fields (columns), and cells. Columns and rows are used to display data in a table. All the data in the table that is relevant to a data type is organised into rows.

A row is a horizontal grouping of data while a column contains vertically-aligned cells. In a row, the data is read from left to right, while in a column, the data is read from top to bottom.

In the screenshot below, every row within the “All Interviews” table is in the database "Applicant Tracker.”

enter image description here

A cell is the intersection of a row and a column. The data is stored in the cell. In the screenshot below, the cell containing “Valery Dugall” is in row 7.

enter image description here

In further sections, you’ll find everything you need to get started. You don’t have to worry about learning all about Baserow on your own: we put together some tips to help you grow familiar with the platform quickly.

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!