Skip to main content

Database Views

Workflow86 databases support multiple ways to visualize and interact with your data through different views. You can switch between views to see your data from different perspectives and work with it in the way that best suits your needs.

Switching between views​

To switch between views, use the view switcher in the toolbar at the top of your database.

The available views are:

  • Table - Traditional spreadsheet-style view (default)
  • Kanban - Visual board view with columns based on a grouping field
  • Calendar - Monthly calendar view (requires a datetime column)
  • Feed - Chronological feed grouped by time period (requires a datetime column)
  • Gallery - Card-based view grouped by a field
note

Calendar and Feed views are only available if your database has at least one datetime column.

View settings​

When using Kanban, Calendar, Feed, or Gallery views, a settings bar will appear allowing you to configure view-specific options.

Title column​

All non-table views allow you to select a "Title" column that determines what text is displayed as the primary label for each record. By default, the Record ID is used, but you can select any text column to display a more meaningful value.

Table view​

The Table view is the default view for databases. It displays your data in a traditional spreadsheet format with rows and columns.

In Table view, you can:

  • Sort columns by clicking on column headers
  • Filter data using the filter row
  • Edit cells by double-clicking
  • Add new records and columns
  • Select and delete records

For more details on working with the Table view, see the Database Page documentation.

Kanban view​

The Kanban view displays your records as cards organized into columns based on a grouping field. This is ideal for visualizing status-based workflows, project stages, or any categorical grouping.

Setting up Kanban view​

  1. Click the Kanban icon in the view switcher
  2. Select a column to "Group by" from the dropdown - this determines how records are organized into columns
  3. Optionally select a "Title" column to customize what text appears on each card

Working with Kanban view​

  • View cards: Each record is displayed as a card showing key fields from the record
  • Drag and drop: Drag cards between columns to update the grouping field value
  • Click to edit: Click on a card to open the full record details
  • Add records: Click the "+" button on a column header to add a new record with that column value pre-filled
  • Expand columns: Click "Show more" at the bottom of a column to see additional cards if there are many records
tip

Kanban view works best with text or list columns that have a limited set of values, such as "Status", "Priority", or "Category" fields.

Calendar view​

The Calendar view displays your records on a monthly calendar based on a datetime column. This is perfect for tracking dates, deadlines, events, or any time-based data.

Setting up Calendar view​

  1. Click the Calendar icon in the view switcher (only visible if you have datetime columns)
  2. Select a datetime column as the "Start date" - this determines where records appear on the calendar
  3. Optionally select an "End date" column to display events that span multiple days
  4. Select a "Title" column to customize what text appears on calendar events

Working with Calendar view​

  • Navigate months: Use the left/right arrows to move between months, or click "Today" to jump to the current month
  • View events: Records appear as colored bars on their respective dates
  • Multi-day events: If you've selected both start and end date columns, events will span across days
  • Click to edit: Click on an event to open the full record details
  • Add records: Hover over a day and click the "+" button to add a new record with that date pre-filled
  • Overflow indicator: If a day has more than 3 events, a "+X more" indicator shows the overflow count
note

Events are automatically color-coded based on the Title column value to help distinguish between different records at a glance.

Feed view​

The Feed view displays your records in a chronological list grouped by time period. This is ideal for activity logs, news feeds, historical records, or any data where recency matters.

Setting up Feed view​

  1. Click the Feed icon in the view switcher (only visible if you have datetime columns)
  2. Select a datetime column to "Sort by" - this determines the chronological order
  3. Select a "Title" column to customize the header text for each record

Working with Feed view​

  • Time groupings: Records are automatically grouped into sections like "Today", "Yesterday", "This Week", "Last Week", "This Month", and by month/year for older records
  • Expand records: Click "+X more" on a record to expand and see all fields
  • Click to edit: Click on a record card to open the full record details
  • Color coding: Each record has a colored header based on its title value for visual distinction
tip

Feed view is excellent for reviewing recent activity or finding records from specific time periods without having to filter or sort manually.

The Gallery view displays your records as cards arranged in groups. This provides a visual overview of your data with each record shown as a card containing its key fields.

  1. Click the Gallery icon in the view switcher
  2. Select a column to "Group by" from the dropdown - this determines how records are organized
  3. Select a "Title" column to customize the card headers
  • Grouped cards: Records are organized into collapsible groups based on the selected grouping column
  • Card preview: Each card shows a preview of the first 4 fields, with an option to expand
  • Expand cards: Click "+X more fields" on a card to see all fields
  • Expand groups: Click "Show more" at the bottom of a group to see additional cards
  • Click to edit: Click on a card to open the full record details
  • Color-coded groups: Each group has a unique color for visual distinction
tip

Gallery view is great for getting a quick overview of records organized by category, status, or any grouping field you choose.

URL parameters​

View settings are preserved in the URL, allowing you to share links to specific views with your team. The URL parameters include:

  • view - The view type (table, kanban, calendar, feed, gallery)
  • kanbanColumn - The grouping column for Kanban view
  • calendarColumn - The start date column for Calendar view
  • calendarEndColumn - The end date column for Calendar view
  • feedColumn - The sort date column for Feed view
  • galleryColumn - The grouping column for Gallery view
  • displayColumn - The title/display column for non-table views

For example, to share a Kanban view grouped by "Status" with the "Name" column as the title:

/database/abc123?view=kanban&kanbanColumn=status_col_id&displayColumn=name_col_id