Guide
Basic
Automation Guide
Database
Integration Guide
Dashboard
Self-hosted
Open API
Business AI Agent Template
Cookbook
Reference
Automation Triggers
Automation Actions
Integrations
Node Resources
Database Views
Database Fields
Dashboard Widgets
Missions
Ai Wizard
Formula
Space
Release Notes
Videos

Database Views

A view is a tool that displays data from a database.

Multiple views can share the same data source but show different sets of information in various formats. Think of a view as a real-time updated window that only displays data you care about.

Types of views

In Bika.ai, main view types include:

View Type

Display Style

Best Use Cases

Grid View

Traditional spreadsheet layout with columns (fields) and rows (records)

Managing large datasets (e.g., customer lists, product inventories)

Gallery View

Visual card display using images from attachments as covers

Showcasing business cards, product images, or menus requiring visual presentation

Kanban View

Task cards grouped in columns representing statuses/stages

Drag-and-drop workflow management (e.g., tracking project stages)

Gantt View (Coming soon)

Timeline view showing task durations/dependencies

Project planning and progress tracking (Coming Soon)

Form View (Coming soon)

Custom data entry forms with shareable links

Streamlining external data collection (Coming Soon)

More details: Help Center > Views

Basic operations of views

Create a View

  1. Open your base database page.
  2. Click + New View in the view list (top navigation bar).
  3. Name your view, select a view type, and saving.

View setting

Each view can be independently configured.

Access Settings:

  1. Click ••• next to the view name.
  2. Select "View Settings", and adjust the content displayed in the view settings panel as needed

Filter

The Filter function allows you to display only the data that meets certain criteria.

For example, you can set conditions to display only tasks with the status "Completed".

Setup method:

  1. Go to the Filter option in the view settings.
  2. Select one or more fields and set the corresponding conditions.

Group

The Group function can categorize and display data by specified fields.

For example, in customer data, you can group by region.

Operation steps:

  1. Enter the view settings and find the group settings.
  2. Select the field for grouping.
  3. The data will be automatically classified and displayed according to the selected fields.

Field sorting and hiding

You can customize the order in which fields in the view are displayed and whether they are hidden.

Attention:

  • The fields in the first column are fixed and cannot be sorted or hidden.
  • Other fields can be changed in order by dragging the left handle, or by clicking the right eye icon to hide.

Operation steps:

  1. Enter View Settings and click Field Settings.
  2. Drag or click the corresponding icon to adjust the field display.

Set cover

In the Gallery view and Kanban view, you can set a cover image for each card.

Operation steps:

  1. Ensure that the attachment field is created in the data table.
  2. Find the Cover Settings option in View Settings.
  3. Select the corresponding attachment field as the cover source.

Bika.ai will automatically use the picture in the attachment as the card cover.

Set card layout

You can configure the layout in Gallery view and Kanban view to control how many cards are displayed per row.

Setup method:

  1. Go to the number of cards option in the view settings.
  2. Set the number of cards displayed per line.

More cards will reduce the width of individual cards to accommodate different screens and display needs.

Delete view

If you no longer need a view, you can delete it.

Operation steps:

  1. Click the "More" icon on the right side of the view list.
  2. Select the "Delete" option.
  3. Click Confirm Delete View in the pop-up modal.
bika cta

Recommend Reading

Recommend AI Automation Templates

Device Asset Management
A comprehensive Device Assets Management Template designed to track devices, manage repair service requests, and streamline client support. With an integrated form for clients to submit service requests, automated technician assignment, and customer notification upon task completion, this template simplifies device maintenance and customer communication
Diary reminder
A simple diary template that helps you record your thoughts and feelings every day. It includes a reminder to fill in your diary every night and a weekly summary report of your diary entries.
Digital Asset Management
This template helps design teams and project managers manage the progress of design projects. It allows you to track task status, priorities, due dates, and responsible team members.
Digital Marketing Strategy
Effortlessly plan and track digital marketing initiatives with this template. Align goals with tasks, monitor progress, and use automation to send reports to Slack upon goal completion for seamless collaboration.
Scheduled message reminders for DingTalk groups
Utilize the powerful functions of Bika to automate the notification and reminder processes in your DingTalk groups. You can easily send various types of custom robot messages, including text, links, Markdown, ActionCard, and FeedCard. This automated solution not only saves your precious time but also improves the efficiency and professionalism of information dissemination. It is an ideal choice for you to enhance team collaboration and communication efficiency.
Dynamic Email Automation for Partner Onboarding
Dynamic Email Automation for Partner Onboarding simplifies the onboarding process by automating personalized emails and follow-ups. It ensures timely communication, tracks partner engagement, and reduces manual work. With automated reminders and seamless integration, your team can focus on building stronger partnerships while the system handles the rest.