Use fields in Base

10 min read
Desktop
Mobile
more
Audio/video is not supported Please TryRefresh
Play
00:00 / 00:00
00:00
Fullscreen
1x
  • 0.5x
  • 0.75x
  • 1x
  • 1.5x
  • 2x
Click and hold to drag
I. Intro
The columns in Base are called fields. There are different field types that determine the type of data that can go into each field, ensuring data standardization. There are three major categories of fields that cater to a wide range of scenarios.
Note: The first column of the Base is the index field, which cannot be deleted, moved, or hidden.
Category
Field type
Description
Basic
Text
For entering text, supports special symbols such as emojis, and line breaks can be added by pressing Enter + Shift.
Single option
A single option can be selected for the record. Colors and options can be customized.
Multiple options
Multiple options can be selected for the record. Colors and options can be customized.
Person
Internal members or external contacts can be added. Multiple people can be added to a single record.
Group
Internal or external groups can be added.
Date
Various display formats for date and time are supported.
Attachment
Multiple file types can be uploaded as attachments.
Number
Numbers can be displayed in the form of decimals, percentages, or currencies.
Checkbox
Select a checkbox to mark a record as "completed".
Hyperlink
For entering URLs. URL text can be edited.
Formula
Fields can be used in formulas for calculation.
Lookup
Based on the LOOKUP function, this field can be used to find data that meets specified conditions.
Business
Flow
Step names can be configured to show the progress or status of a flow
Button
Users can click the button in this field to trigger an automation action
Numbering
A uniquely identifiable and auto-incrementing number is assigned to each record.
Phone number
Contacts from your phone can be imported. Click the content in the field to call or send text messages.
Email
The email of the person adding the record can be automatically added. Checks that the data entered is in the proper email format. Makes sending emails from Base easier.
Location
Records location information or used to get the real-time location.
Barcode
Scan and read barcodes and QR codes to extract data.
Progress
Can be used to visualize the progress of projects and tasks.
Currency
Adds currency symbols. The number of decimal places can be specified.
Rating
Suitable for evaluation, survey, and other use cases. The scale and scale can be customized.
Advanced
Two-way link
For two-way linking of data across two tables.
One-way link
For one-way linking of data across two tables.
Creator
The creator of each record, auto-filled.
Editor
The latest editor of each record, auto-filled.
Created at
The creation time of each record, auto-filled.
Last update
The time at which the record was last edited, auto-filled.
II. Steps
Create a field
Method 1: In grid view, click the + icon on the right side of the last field.
250px|700px|reset
Method 2: In grid view, Gantt view, or calendar view, click Customize Field > New field. In kanban view and gallery view, click Customize Card > New field. Grid view (left image) and kanban view (right image) shown below.
250px|700px|reset
250px|700px|reset
Method 3: Expand the record and click New field.
250px|700px|reset
Method 4: Right-click the name of an existing field or hover over the field name and click the icon, and select Insert Left or Insert Right. A text field will be added to the direction you specified.
250px|700px|reset
When you create a field using method 1, 2, or 3, field type recommendations will appear in the panel.
The recommendations are generated by AI based on the name of the base, table, and fields and the field types. Select a recommended field type, configure settings as needed, and click Confirm to add the recommended field. New recommendations will be given when a new field is created.
Note: Field recommendations are only available on the web version of Base.
250px|700px|reset
Modify and manage fields
Note: Using grid view is recommended for modifying, copying, and deleting fields.
  • Modify field name and type.
  • Method 1: Double-click the field name.
  • Method 2: Right-click the field name or hover over the field name and click the icon, then select Edit Field.
250px|700px|reset
250px|700px|reset
  • Edit field description: Right-click the field name or hover over the field name and click the icon, then select Edit Field Description.
250px|700px|reset
  • Duplicate or delete field: Right-click the field name or hover over the field name and click the icon, then select Duplicate Field or Delete Field.
  • You can also click Customize Field, then click the ··· icon to the right of the field name and select Delete.
250px|700px|reset
  • Hide or display field:
  • Method 1: Hide field: Right-click the field name or hover over the field name and click the icon, then select Hide Field.
  • Method 2: Click Customize Field and click the Eye icon to hide a field. Click the Eye icon again to unhide it.
250px|700px|reset
250px|700px|reset
  • Freeze field:
  • Method 1: Right-click the field name or hover over the field name and click the icon, then select Freeze up to This Field. All fields, from left to right, up to the field you've selected will be frozen. You cannot individually unfreeze a field inside that range.
  • Method 2: Hover over the freeze line and drag left or right to adjust the freeze range.
  • Note: The index field is frozen by default. Drag the freeze line to the left to unfreeze the index field.
250px|700px|reset
250px|700px|reset
  • Rearrange field order.
  • Click the field name to select it and drag the field left or right.
  • Click Customize Field and drag the ⋮⋮ icon of the field to where you need it to go.
  • Note: The position of the index field cannot be changed.
250px|700px|reset
III. FAQs
Why can't I delete or hide the first field?
The first field of the base is the index field, which cannot be deleted, moved, or hidden. Changing other fields into the index field is not supported.
How do I display hidden fields?
Click Customize Field at the top of the base and click the Eye icon to the right of the field name to unhide the field.
250px|700px|reset
How do I unfreeze fields?
You can adjust the freeze range by dragging the freeze line. You can't unfreeze individual fields.
Can the value of a field in a Base table be center aligned?
No.
Written by: Lark Help Center
Updated on 2025-03-08
How satisfied are you with this content?
Thank you for your feedback!
Need more help? Please contact Support.
rangeDom
rangeDom
rangeDom
rangeDom
rangeDom