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 Fields
A field is a vertical data column in a database, similar to the header column of an Excel table. Each field stores specific types of information.
Fields type
Bika.ai supports over 20 field types for different scenarios:
- Basic data: Single-line text (product names), Multi-line text (descriptions), Number (prices), Percentage (completion rates)
- Time management: Date & time (order creation), Date range (event duration)
- Selections: Single select (customer ratings), Multi-select (product tags), Checkbox (approved status)
- Contact info: Phone (customer mobile), Email (user email), URL (product links)
- File management: Attachment (contract documents)
- Special features: Formula (auto-calculated amounts), Auto-number (order IDs)
- Collaboration: Member (task owner), Created by (record author)
More details: Help Center - Fields
Basic operations of fields
Create Fields
New database include 3 default fields. To add more:
- Click the + button at the right end of the column headers
- Configure in the pop-up window:
- Field Name: Display title (e.g., "Product SKU")
- Field Type: Data format selection (required)
- Description: Additional context shown in record details
- Field Settings: Type-specific configurations
- Required: Enforce mandatory input in forms/new records
- Click Save
Edit Fields
Modify existing fields anytime:
-
Quick edit: Double-click the column header
-
Full edit: Hover over the field title → Click ... → Edit
Open the editing panel to modify, and it will take effect after saving.
Delete Fields
Remove unneeded fields (except first filed):
- Hover over the field title → Click ... → Delete Field
- Confirm in the pop-up modal
Recommend Reading
- AI Data Automation with Bika.ai: Unlocking New Potential for Telegram Scheduled Notifications in Announce important changes
- Revolutionize Your Social Media with AI Automated Tweets
- Feishu Scheduled Notifications: Airtable Alternative to Reminding project deadlines
- Bika.ai vs Airtable: To Automating reminder schedules
- Data Automation with Bika.ai: Unlocking New Potential for Email Reminder in Delegating tasks
Recommend AI Automation Templates
Creative agency proposal planning
Received a new RFP from a prospective client? Utilize this comprehensive template to guide your team through the RFP lifecycle, ensuring timely progress and a structured approach to secure that significant contract.
B2B AI CRM
AI automation to manage your clients, prompt you or your sales team to write visit records every week, suitable for B2B sales teams targeting enterprise organizations.
Customer After-Sales Service Management
This template integrates customer case tracking, after-sales service, employee training, and customer information management, providing comprehensive support for delivering a high-quality customer experience. And can be used in scenarios such as retail and e-commerce, residential property maintenance, home appliance installation and repair, and domestic services.
Customer development CRM
A customer development CRM template to manage customer personas, interviews, problem statements, and feature enhancements for product improvement
Customer projects
This template is ideal for consulting companies, law firms, and sales since it helps calculate the hours worked that require compensation, provides a high-level overview of the progress of your projects, and creates a collaborative platform.
Customer Satisfaction Form and Analysis
The Customer Satisfaction Form and Analysis Template simplifies collecting, organizing, and analyzing customer feedback. With structured forms, Automated email reminder for followers to categorize insights, and a detailed dashboard, this template helps teams measure satisfaction, identify trends, and take action to improve products and services.