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

AI Automated Task Management

Helps teams efficiently manage weekly tasks. Through a series of automation tools, including task summaries, progress reminders, and personal summary reports, team members can promptly obtain task information and progress, thereby improving collaboration efficiency and work transparency. By using these automation features, teams can maintain efficient operations and ensure that each member has a clear understanding and sense of responsibility for their tasks.

Diary reminder

Keep your thoughts organized with this Diary Reminder Template. Track daily writing, manage your diary entries, and receive automated nightly reminders. Generate weekly summary reports to review your life logging progress, enhance self-reflection, and maintain consistent journaling habits. Perfect for personal diary management, writing tracking, and improving productivity.

Eisenhower Matrix

Boost your personal productivity and manage tasks efficiently with the Eisenhower Matrix. Automate task actions, track task status, and prioritize projects based on importance and urgency. Perfect for individuals and teams seeking smarter time management and actionable task insights.

Google Analyst

Step-by-step guide to connect your Google Analytics 4 (GA4) property to the Google Analyst agent. Covers creating a Google Cloud service account, enabling the Analytics Data API, granting GA4 Viewer access, and configuring the agent with supported metrics like sessions, users, bounce rate, conversions, and more. Perfect for quickly setting up GA4 data reporting in Bika.ai

X/Twitter Manager

An AI-powered Twitter Assistant that helps content creators draft viral tweets with auto-polish, generate tweet ideas, and schedule posts using one-click automation. Grow your engagement and effortlessly boost your Twitter follower growth.

3-Day Outreach Email Campaign

Quickly launch a 3-day automated email outreach campaign with this ready-to-use email outreach template. Run an email drip sequence of automated welcome emails for new users to boost activation, retention, and early engagement. This workflow helps you send the right message on each of the first three days, pause the sequence when users reply, and avoid over-contacting them. Ideal for customer success teams, SaaS product managers, marketers, and startup founders who want a simple, automated way to guide new users into your product.