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

• Data Automation with Bika.ai: Unlocking New Potential for Weekly meeting reminder (WeCom) in Risk management review
• AI Data Automation with Bika.ai: Unlocking New Potential for Rotating Duty Reminder(Slack) in Duty rotation arrangement
• Revolutionize Team Collaboration with Bika.ai's Slack Channel Scheduled Notifications
• Airtable Pricing vs. Bika.ai Pricing: Which is More Advantageous for Risk Training and Drills?
• Bika.ai vs Airtable: To Improve customer communication