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

Admin panel The Admin Panel is a centralised interface for Instance admins to manage the Enterprise account for their organization.
Billable user A billable user counts towards the users your subscription plan allows.
Cell A cell is the area formed by the intersection of a column and a row. It is the basic unit of data storage. Each grid-like pattern contains cells to store the information in them.
Database A database is made up of tables. A Baserow database may contain numerous tables containing data for various projects.
Field/Column A field is a collection of values of the same data type. Each column in a table represents a field. Each field is a data structure that holds a defined data type, such as text, numbers, dates, boolean, collaborators, select and URL.
Group A Group is a workspace. Groups provide collaborative access to databases.
Group admin Admins are in charge of the Group’s management. Admins can assign permissions to group members.
Group Member Members are people within your team who use Baserow. Groups admins in the Free, Self Hosted Premium plan, or SaaS Hosted Premium plan can assign can grant users access to the group as Admins or Members. Baserow Advanced and Enterprise plans come with advanced user management to boost data protection and privacy requirements.
Hosted A hosted application is created on baserow.io and accessed over the internet through Baserow’s servers.
Instance ID The instance ID is the unique identifier of your Baserow copy to which the license will be connected to it. Your Self-hosted Instance ID is required to upgrade users to the premium plan if you have installed Baserow on your own server.
Instance-wide admin An Instance-wide admin in the self-hosted instance is the person who set up the instance. Only Instance-wide admins can manage licenses, subscriptions and site-wide settings. The account that installs and sets up Baserow is automatically an Instance-wide admin and has staff privileges. Instance-wide admins have server-wide access over all users and all group data. They have the ability to revoke an existing Instance-wide admin’s own staff permissions. The first user who signed up is automatically a server-wide admin.
Kanban view Kanban view allows you to visualize data at a glance and prioritize moving those tasks through the workflow. With the Kanban View, you can view your tasks in a new way by arranging them as cards on a board.
License A premium license gives you access to all premium features in the self-hosted version.
License key A licence key is a unique string of characters that will allow you to register your Baserow self-hosted instance. It’s not possible to use the same key on two different installations.
Role based permissions A role specifies a set of permissions that manages user access or lets a user perform specific tasks. You can assign or restrict one of the following roles – Admin, Builder, Editor, Commenter, and Viewer - to users. Role based permissions feature is only available to users on baserow.io SaaS Advanced and Self-hosted Enterprise plans.
Row Each row in a table represents a unique record.
Row ID A Row ID is a numerical column automatically filled with an incrementing integer value when a row is inserted.
Self-hosted Self-hosting is the practice of hosting and managing your applications on your own server. Self-Hosted software is also known as “on-premises” or “in-house” hosting.
Single sign-on (SSO) Single Sign On (SSO) allows users to log in just one time with one set of credentials to get access to all corporate apps, websites, and data for which they have permission. With single sign-on (SSO), users can log in to Baserow with one set of login information.
Snapshot A snapshot is a snapshot of the base taken directly by the user at a specific time.
Table All of the data in a database is stored in tables. Data is logically organised in rows and columns in tables. You can store multiple tables in a single database.
Table ID A table ID is a value that uniquely identifies a table in a database. It assigns an identifier to a table to easily access it via API.
View A view determines how records in a table will be displayed and manipulated. Each view in a table is based on a model of the data. Data edited in a view will reflect across all views in the table. Grid view is the default view type, but there are also form, gallery, and kanban view types.

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!