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:

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.

Row height

The row height setting allows you to adjust the height of each row in the grid view to suit different display needs.

Steps:

1. Go to the view settings and find the Row height option.
2. Select the appropriate row height option, such as Medium, Tall, or Extra Tall.
3. The view automatically adjusts based on your selections.

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 database.
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.

Recommend AI Automation Templates

Auto Send Pay Slips

Automate the entire payroll distribution process with the Auto Send Pay Slips template. Effortlessly send accurate employee pay slips, manage payroll data, and streamline your payroll approval process. Use onboarding form templates, employee roster templates, and payroll sheet templates to keep payroll data management organized and error-free. Generate monthly payroll reports, improve payroll accuracy, and enhance labor cost management as part of automated HR workflows. Ideal as an HR automation tool for HR and finance teams that need reliable, standardized payroll operations.

Automated Stock Data Retrieval (JavaScript)

The Automated Stock Data Retrieval (JavaScript) template automatically fetches US stock data every day and writes it into a structured table, giving you clean, consistent time series for analysis. Use it as part of your financial data automation stack to power stock trend analysis, dashboards, alerts, and quantitative analysis data for models and backtests. Designed for financial analysts, investment managers, data scientists, quants, and portfolio managers, it saves time on manual data collection so you can focus on research, strategy, and better investment decisions.

Resume Analyzer

HR AI Assistant is designed to streamline your resume workflow. It automatically extracts key candidate details from resumes (screenshots or PDFs) and organizes them into your datasheet. Simply upload a resume, and the assistant will handle the rest — making your hiring process faster, more accurate, and more efficient.

AI Sales Report

The AI Sales Report template turns raw sales data analysis into automated sales reporting and a clear weekly sales report for every store. Use AI sales analytics and AI retail analytics to run sales performance analysis, sales performance monitoring, and sales trend analysis across locations. It works like AI business intelligence for retail teams, supporting business analyst reporting, automated report delivery, and trend analysis for sales so managers and analysts can make faster, data‑driven decisions without manual reporting.

Customer Support Scribe

Customer Support Scribe is an AI tool designed to automate customer support and improve AI customer communication. It works as an FAQ generator and SOP generator, streamlining helpdesk automation with professional, ready-to-use support templates for teams.

Business Development CRM

Streamline your business development CRM with a powerful business development template designed for effective partner management and opportunity tracking. Use this system to manage business relationship management workflows, organize key contacts, and centralize all partner information in one place. Track the full business development process and business development workflow—from initial outreach to signed partnership deals—while keeping interactions, contracts, and opportunities aligned. Ideal for teams that need a structured way to manage partnerships, improve collaboration, and stay on top of every opportunity in their pipeline.