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:

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

1. 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):

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

• Data Automation with Bika.ai: Unlocking New Potential for Send Emails in Bulk in Increase customer satisfaction
• Solve Website Downtime Woes with Bika.ai's HTTP Monitoring Template
• Data Automation with Bika.ai: Unlocking New Potential for Automated Stock Data Retrieval (JavaScript) in Data visualization
• Automated Birthday Email Celebration: Airtable Alternative to Send birthday anniversary wishes
• AI Project Issues and Tickets: Airtable Alternative to Reporting progress