Guide
Basic
Automation Guide
Database
Dashboard
Integration Guide
Self-hosted
Business AI Agent Template
Open API
Cookbook
Reference
Automation Triggers
Automation Actions
Integrations
Node Resources
Database Views
Database Fields
Dashboard Widgets
Missions
Ai Wizard
Formula
Space
Release Notes
Videos

Database - Fields

Database fields contain details or metadata for each record in a database. Database fields hold information or metadata for each entry in a database. These fields can take various forms, allowing data to be stored as text, single or multiple selections, images, checkboxes, numbers, user tags, and more.

Single Line TextSingle Line TextStores brief single-line text, suitable for titles, names and other concise information
Multi-line TextMulti-line TextUsed for storing long text content, such as detailed descriptions, comments or article body text
CheckboxCheckboxProvides a yes/no option checkbox, suitable for status marking or simple boolean value selection
CurrencyCurrencySpecifically for storing and formatting currency amounts, supporting different currency symbols and precision settings
Date TimeDate TimeStores precise date and time information, suitable for scenarios that require recording exact time points
Date RangeDate RangeStores time periods or date ranges, including start and end time points, suitable for project cycles, event times and other scenarios
NumberNumberStores numeric data, supports integers and decimals, can set precision and format
PercentagePercentageStores percentage values, automatically formatted as percentages, suitable for progress, ratios and other scenarios
PhonePhoneSpecifically for storing phone numbers, suitable for contact information, customer profiles and other scenarios
EmailEmailSpecifically for storing email addresses, suitable for contact information, notifications and other scenarios
RatingRatingStores rating information in the form of stars or numerical values, visually displaying evaluation levels
Single SelectSingle SelectSelects a single option from a predefined list of options, suitable for status or classification scenarios
Multi SelectMulti SelectSelects multiple options from a predefined list of options, suitable for multi-tag classification
URLURLStores web link addresses, supports direct link jumping for access
MemberMemberStores system member information, can select single or multiple members as field values
Created ByCreated ByAutomatically records the user information of who created the record, convenient for tracking record sources
Modified ByModified ByAutomatically records the user information of who last modified the record
Created TimeCreated TimeAutomatically generated date and time string when a new record is created, cannot be changed manually
Modified TimeModified TimeAutomatically generated date and time string when a record is updated, cannot be changed manually
LinkLinkCreates bidirectional associations with other databases, enabling inter-database data references and relationship maintenance
AttachmentAttachmentAllows uploading and storing various types of files as record attachments, such as documents, images or compressed packages
FormulaFormulaAutomatically calculates values through formulas, can reference other fields and perform mathematical or logical operations
Auto NumberAuto NumberAutomatically generates a unique sequence number for each new record, suitable for order numbers, work order numbers and other scenarios
LookupLookupAutomatically looks up and displays values of specific fields from linked databases, enabling dynamic data references
VideoVideoStores video files, supports uploading, previewing and playback functionality (Coming Soon)
VoiceVoiceStores audio files, supports recording, uploading and playback functionality (Coming Soon)
PhotoPhotoStores and displays image files, supports preview and thumbnail functionality (Coming Soon)
APIAPIStores API interface information for interaction and data exchange with external systems (Coming Soon)
AI TextAI TextAI-generated text content that can reference data within database, suitable for customer service replies, product descriptions, content summaries and other scenarios to improve creation efficiency
AI VoiceAI VoiceAI-generated voice and audio content suitable for voice assistants, podcasts and other scenarios (Coming Soon)
AI PhotoAI PhotoAI-generated images and visual content suitable for product displays, social media and other scenarios (Coming Soon)
AI VideoAI VideoAI-generated videos and animated content suitable for advertising, social media and other scenarios (Coming Soon)
Video EditingVideo EditingStores video clips that have been edited, preserving editing information and timeline (Coming Soon)
JSONJSONStores structured JSON format data, suitable for complex data structures or API response content (Coming Soon)
CascaderCascaderProvides multi-level linked dropdown menus, suitable for data selection with hierarchical relationships, such as regional selection (Coming Soon)
One Way LinkOne Way LinkCreates a one-way association with other databases, can only view data from the linked database from the current database (Coming Soon)
DocumentDocumentStores rich text documents that support Markdown format, allowing direct creation and editing of document content within cells
ButtonButtonCreates interactive clickable buttons that can trigger preset automated operations or events when clicked (Coming Soon)
bika cta