NocoDB terminologies

Familiarize yourself with key terms used across NocoDB.

Layout

The layout below shows the main parts of NocoDB's user interface.

image

  1. Minibar: The vertical bar on the far left with icons for quick access to Search, Workflows, Integrations, Help, and Settings.

  2. Sidebar: Displays the base name (e.g., "Sales CRM"), a Create New button, and a tree of all tables and their views. Each table and view shows its icon for easy identification.

  3. Navbar: The horizontal bar at the top showing the current breadcrumb path (Base > Table > View), along with tabs for Data, Details, and Extensions, and the Share button.

  4. Toolbar: Located below the Navbar, provides tools for the current view — Fields, Filter, Group, Sort, Colour, row height, and search.

  5. View Area: The central workspace displaying records in the selected view format (Grid, Form, Gallery, Kanban, Calendar, Timeline, List, or Map). In Grid view, data is shown in rows and columns with fields like Activity, Type, Date, Outcome, and Notes.

  6. Footbar: The bottom bar showing the total record count and field aggregations (e.g., Filled, Min, Percent Filled) when configured.

Terminologies

Core Concepts

TermDescription
WorkspaceTop-level organizational unit that contains one or more bases. Manages user access and permissions across all bases within it.
BaseA container for one or more related data sources, each comprising multiple tables. Think of a base as a project workspace for organizing structured data.
TableOrganizes data into rows (records) and columns (fields). Each table represents a distinct entity and can be linked to other tables through relationships.
FieldA named column within a table that holds values of a specific type (e.g., text, number, date). All records in a table share the same set of fields.
RecordA single entry in a table, represented as a row. Contains values across multiple fields.
CellThe intersection of a row and a column. Holds the actual value of a field in a specific record.

Views

TermDescription
ViewDefines how records in a table are displayed and interacted with. Each table can have multiple views with their own filters, sorts, and field visibility.
Grid ViewDefault spreadsheet-like view displaying data in rows and columns.
Form ViewPresents fields as a form for data collection. Can be shared publicly.
Gallery ViewDisplays records as cards, useful for visual content like images or profiles.
Kanban ViewOrganizes records into columns based on a Single Select or User field, useful for tracking status or stages.
Calendar ViewDisplays records on a calendar based on a date field.
Timeline ViewShows records along a horizontal timeline based on date ranges.
List ViewHierarchical outline view that displays records organized through LTAR relationships.
Map ViewPlots records on a map using a Geometry or GeoData field.
Shared ViewA publicly accessible link to a view, optionally password-protected.
Collaborative ViewA view shared across all base members, where changes to filters, sorts, or field visibility are visible to everyone.
Locked ViewA view where the configuration (filters, sorts, field visibility) is locked and cannot be modified until unlocked by a Creator or Owner.
Personal ViewA view whose configuration can only be modified by its owner. All base members can still see the view and its data — only editing the view's configuration is restricted.

Relationships & Computed Fields

TermDescription
Link To Another Record (LTAR)A field type that creates a relationship between two tables, allowing records in one table to reference records in another.
LookupA field that retrieves and displays a value from a linked table via an LTAR relationship.
RollupA field that aggregates values (e.g., sum, count, average) from linked records in another table via an LTAR relationship.
FormulaA computed field whose value is derived from an expression involving other fields, operators, and built-in functions.

Automation & Integrations

TermDescription
WebhookSends data to a specified URL when a configured event occurs (e.g., record created, updated, or deleted), enabling integrations with external services.
WorkflowA visual automation that runs a sequence of actions in response to a trigger event, with support for conditions, loops, and delays.
ScriptA JavaScript-based automation that can read and modify data across tables, fields, and records programmatically.
IntegrationA configured connection to an external service or data source that NocoDB can interact with.
Data SourceAn external database (e.g., PostgreSQL, MySQL) connected to a base, allowing NocoDB to read and write data directly.

Extensions & Features

TermDescription
DashboardA visual canvas for building charts and widgets that summarize data from your tables.
ExtensionAn add-on app that provides additional functionality such as Bulk Update, Data Exporter, Dedupe, Org Chart, or Page Designer.
NocoDocsBuilt-in document editor with rich text formatting, comments, AI writing assistance, and granular permissions.
NocoAIAI-powered assistant that helps create bases, tables, fields, views, filters, formulas, and select options using natural language.
NocoSyncSyncs data from external tools like GitHub, GitLab, Bitbucket, and Linear into NocoDB tables.

Roles & Permissions

TermDescription
Workspace OwnerThe user who created the workspace. Has full administrative privileges including managing members, roles, and billing.
Workspace MemberA user with access to the workspace. Can be assigned roles such as Owner, Creator, Editor, Commenter, or Viewer.
Base OwnerThe member who created the base or was assigned the owner role. Has full control over the base configuration and data.
Base MemberA user with access to a base, assigned a role that defines their permissions (Owner, Creator, Editor, Commenter, or Viewer).

UI Elements

TermDescription
Expanded RecordA detailed view of a single record, showing all fields and their values in a panel or modal.
ModalA UI overlay for a specific task such as editing a record or confirming an action. Blocks access to the rest of the interface until dismissed.