It seems you may be using English. Would you like to go to the international site? bika.ai
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:

  1. Click the + button at the right end of the column headers
  2. 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
  3. 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):

  1. Hover over the field title → Click ...Delete Field
  2. Confirm in the pop-up window
bika cta

Recommend Reading

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