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

The newly created database will come with three basic fields as examples. You can delete them or change the field types, or directly add new fields.

For field operations, Bika.ai provides two different interaction path methods, and there will be slight differences in application scenarios and logical effects between the two.

The first one is that you can operate directly on the grid view interface. Click the "..." in the column header to enter the "field editor" interface. You can also click the "+" button to quickly add a new field. This method is suitable for scenarios where there are a small number of fields to operate.

The second one is that you can click the "..." button in the upper right corner of the database interface to enter the database editor. Perform various complex and batch field configurations in the database editor.

Create Fields

1. You can click the "+" button on the far right of the database header to create a new field. You can also click the "..." in the upper right corner of the interface to enter the database editor and then add. The difference between the two:

   Difference	Who can operate?	Will the field appear in other views?
   Create field from view header	Members with "Can manage" permission for the database	The field created in the header of view A only appears in view A and will not appear in other views. (You need to enter the database editor and manually switch the display.) If the type of the new field is an "Link" field, the current view of this database will display the field, and the associated database will hide the field.
   Create field from database editor	Members with "Can manage" permission for the database	If you create a new field in the field list of the database editor, by default, this field will not be displayed in all views. You need to enter the view editing interface and manually switch to display it. If the type of the new field is an "Link" field, then this field is hidden by default in both associated database A and B.

   

2. Fill in information in the popped-up field editing interface.

   
   • Field name: The name displayed for the field
   • Field type: Define the data format (such as text, number)
   • Field description: Supplement detailed explanations and can be seen in the record details
   • Field configuration: Adjust configuration items according to field type
   • Required switch: After checking, when creating a new record, editing a record, or filling out a form, this field cannot be empty. Please note that when a field is set to hidden in a specific view, its required attribute will automatically become invalid in this view. For example, if the "backup email" field is hidden in the "Customer View", even if this field is marked as required, when a user submits a form in this view, no verification will be triggered. The system follows the verification trigger mechanism of "what is seen is what is verified"

3. Click the "Save" button at the bottom to complete the configuration of the field.

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

Display and hiding of fields

The display or hiding settings of fields are very flexible. You can assign different display or hiding states to the same field under different views to meet the needs of different scenarios.

1. Quickly modify the display and hiding of fields through the view toolbar

When you read a database and conduct data analysis, if there are too many displayed fields, it may affect the reading experience. At this time, you can quickly temporarily hide the fields that you do not currently need to view through the "Hide Field" control on the view toolbar.

This way of hiding operations is only effective for you. When other members in the space access the same view, they can still view this field normally.

1. Through the view editor, modify the "global" visibility of fields

Creating multiple views is to recombine and display the data of a database through different filtering conditions and interaction forms, so as to improve the reading experience and work efficiency of members in different business scenarios.

Members with "Can manage" permissions for the database can enter the view editing interface of the database and then perform batch hiding or showing operations on fields. The display or hiding operations in this way take effect for all members of the space. Any member accessing the same view of the database will see exactly the same rows and columns initially.

For example, if a member with "Can manage" permission sets field A to "Hidden" in the view editing interface. Then all members entering this view, whether in the data area or the "Hide field" control on the view toolbar, will not be able to see field A.

Common questions

Q: If field A is set as "required", and this field is in a hidden state under view X. Will the required field verification take effect when creating a record? A: It will not take effect. The system follows the verification trigger mechanism of "what you see is what you verify", and it only takes effect when the field is visible. For example, if the "alternate email" field is hidden in the "customer view", even if this field is marked as required, the user will not trigger verification when submitting the form in this view.

In the following special cases, the required field verification will not take effect:

• When creating or updating database records through Bika.ai's OpenAPI, the required field validation will also not take effect. Please be aware.
• In the view interface, when modifying row records using functions such as "Duplicate record", "Bulk update", and batch deletion by selecting cells, required field validation will not take effect.
• When creating and updating records using the "Create Record" and "Update Record" actions in automation, the required field verification does not take effect.

Recommend AI Automation Templates

ADDIE Instructional Design Model

Use the ADDIE Instructional Design Model as a practical instructional design template to manage your entire course development process. Plan and track e‑learning content development, instructor‑led training design, and training materials development for professional skills courses and employee training programs. This template helps instructional designers, training developers, and education project managers organize tasks, align learning objectives, and streamline course creation for any organization.

Customer Support Scribe

Customer Support Scribe is an AI tool designed to automate customer support and improve AI customer communication. It works as an FAQ generator and SOP generator, streamlining helpdesk automation with professional, ready-to-use support templates for teams.

Automatic subtitling for YouTube URLs

Automatically extract and create subtitles from YouTube videos using our powerful automatic subtitling and auto caption tool. Improve video accessibility, streamline subtitle recognition, and manage YouTube content effortlessly. Perfect for creators, marketers, and managers who need fast subtitle creation, accurate YouTube subtitle extraction, and automatic video captions—all in one seamless workflow powered by Bika.ai.

Coming soon

Automated Currency Data Retrieval (JavaScript)

The Automated Currency Data Retrieval (JavaScript) template runs daily jobs to fetch exchange rates and write them into a table, giving you clean, structured historical exchange rate data without manual copy‑paste. Use it for financial data automation that feeds dashboards, alerts, and automated financial reporting, so finance teams, forex traders, accountants, and analysts always have up‑to‑date FX data. Over time, the template becomes a lightweight risk management tool by helping you monitor currency movements, spot trends, and support better investment and hedging decisions.

AI VAT Invoice Information Recognition (China)

This AI VAT Invoice Information Recognition (China) template uses Baidu AI Cloud to deliver AI invoice extraction and end‑to‑end invoice workflow automation for Chinese VAT invoices. Automatically recognize key fields, verify invoices, and write results into your database to streamline financial data management. Support supplier invoice processing and purchase order invoices in the same flow, reducing manual input, lowering error rates, and helping finance teams, SMEs, accountants, and procurement departments keep VAT invoice records accurate, searchable, and audit‑ready.

14-Day Automated Cold-Email Outreach Campaign

Launch a 14-day automated cold outreach campaign with this done-for-you email outreach template. Run a fully automated email sequence and drip email sequence for outbound email campaigns and outbound sales emails, complete with automated follow ups and lead nurturing emails. Use a clear email campaign workflow to manage automated email outreach, track engagement, and scale cold outreach to influencers, partners, and prospects—without manual follow-ups.