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

Rotating Duty Reminder(Wecom)
Effectively organize team shifts, automatically record and remind about shift information to ensure every member receives timely shift notifications. This includes reminders for meeting rotations, project rotations, operations and maintenance rotations, among others.
Sales Contract Automation Management
This template is designed for the financial management team, focusing on tracking and managing the payment status of cooperative customers to improve the efficiency and accuracy of payment collection.
Sales Strategy
This template helps sales teams set goals, track the progress of strategic plans, and ensure business growth is achieved
Scrum Sprint Task Management Automation
Streamline your Scrum sprint management with this powerful template. Effortlessly organize tasks, track progress, manage bugs, and automate notifications for sprint completion and task updates. Leverage auto-generated tasks from issues or bugs and set up task review reminders to keep your team aligned and ensure timely delivery of sprint goals.
Send Emails in Bulk
Super easy-to-use bulk email sending function, an intuitive data table, enter email addresses or collect them through forms, trigger to send in bulk, and see open rates and reply rates
Send Emails in Bulk (Tag Triggered)
Super simple and easy-to-use bulk email sending feature. An intuitive data table to input email addresses or collect them through forms, trigger bulk sending based on tag changes, and view open rates and reply rates.