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

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

View setting

Each view can be independently configured.

Access Settings:

Click ••• next to the view name.
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:

Go to the Filter option in the view settings.
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:

Enter the view settings and find the group settings.
Select the field for grouping.
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: