Guide
Basic
Automation Guide
Integration Guide
Open API
Template Guide
database
self-hosted
Cookbook
Reference
Automation Triggers
Automation Actions
Integrations
Node Resources
Database Views
Database Fields
Dashboard Widgets
Missions
Ai Wizard
Formula
Space
Release Notes
Videos
Fields type
Fields are vertical data columns in database, similar to header columns in Excel spreadsheets. Each field stores specific types of information.
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)
- Automation: Formula (auto-calculated amounts), Auto-number (order IDs)
- Collaboration: Member (task owner), Created by (record author)
Learn more: Help Center - Fields
Core Operations
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

Delete Fields
Remove unneeded fields (except first column):
- Hover over the field title → Click ... → Delete Field
- Confirm in the pop-up window

Recommend Reading
- Data Automation with Bika.ai: Unlocking New Potential for LinkedIn Post Automation in Post at optimal times
- Solve Payment Status Notification Challenges with Bika.ai's Auto Email Template
- Data Automation with Bika.ai: Unlocking New Potential for Medical Devices Sales Manager with B2B AI CRM
- AI Data Automation with Bika.ai: Unlocking New Potential for Automated Currency Data Retrieval (JavaScript) in Financial Report Automation
- Revolutionize Your Food & Beverage Sales with B2B AI CRM
Recommend AI Automation Templates

Project planning
Even the simplest project has many elements to track. With this comprehensive template, you can easily manage all project elements, ensuring you stay focused and in control throughout the project's lifecycle.

Project tracker
The project tracker template is designed to help teams effectively manage and track project progress. Through this template, users can easily record tasks, assign responsibilities, set deadlines, and update project status in real time.

Regular Invoice Collection for Paid Payments
Regularly collect paid invoices to ensure the finance department receives them on time and manage invoice data

Relationship Care
Record your interpersonal relationships and the activities you engage in with them. The system will automatically remind you in advance and send birthday wishes. Weekly care activities are summarized intelligently through AI, ensuring you never miss an important moment.

Remote Internal Communications Planning
The Remote Internal Communications Planning Template helps you plan, organize, and execute digital content and online events that align with company-wide internal communications objectives. It facilitates collaboration with team members to ensure each piece of content and event is completed on time, with the appropriate resources allocated. The template also provides a platform to share insights with executives and brainstorm ways to further engage employees.

Risk Assessment and Response
This template is designed to assist corporate leadership teams in documenting known risks within various departments (such as commodity price fluctuations or IT budget overruns) and developing corresponding mitigation and contingency plans