Tables & Views

Working with Tables#

A table is the foundation of every database. Each table is made up of columns (the fields you define) and rows (the individual records). You can add as many columns and rows as you need.

Adding Rows#

• Click the + New Row button at the bottom of your table.
• Or start typing in the last empty row — a new one is created automatically.

Adding Columns#

• Click the + button to the right of your existing column headers.
• Choose a column type and give it a name.

Views#

Views let you look at the same data in different ways. Changing a view never alters the underlying data — it just changes how it's presented.

Grid View#

The default view. Your data appears as a familiar spreadsheet-like table with rows and columns. Grid view is great for:

• Browsing and editing data quickly
• Seeing lots of records at once
• Sorting and filtering with full detail

Kanban View#

Kanban view organizes your rows into columns based on a select field (like Status or Priority). Each row becomes a card you can drag between columns. Kanban view is ideal for:

• Tracking tasks through stages (e.g., To Do, In Progress, Done)
• Visualizing workflows
• Moving items between categories with drag and drop

To switch to kanban view, click the View dropdown above your table and select Kanban. You'll be asked to choose which select column to group by.

Filtering#

Filters let you show only the rows that match specific conditions. For example:

• Show tasks where Status is "In Progress"
• Show contacts where Company contains "Acme"
• Show orders where Total is greater than 100

To add a filter:

1. Click the Filter button above your table.
2. Choose a column, a condition (equals, contains, greater than, etc.), and a value.
3. Your table updates instantly.

You can stack multiple filters to narrow things down further. All filters work together — a row must match every filter to appear.

Sorting#

Sorting arranges your rows in a specific order. You can sort by any column — alphabetically, numerically, or by date.

To sort:

1. Click the Sort button above your table.
2. Choose a column and a direction (ascending or descending).

You can add multiple sort levels. For example, sort by Priority first, then by Due Date within each priority level.

Grouping#

Grouping organizes your rows into collapsible sections based on a column's values. For instance, grouping by Department creates a section for each department with its rows nested underneath.

To group:

1. Click the Group button above your table.
2. Choose the column to group by.

Grouping works in both grid and kanban views and makes it easy to scan large datasets at a glance.