Field Types Reference

Comprehensive guide to all field types available in Bases. Learn what each field type does, when to use it, and how to configure it.

Text

Single Line Text

A single line of text. Perfect for names, titles, short descriptions.

Validation: Max length can be configured
Examples: Name, Title, SKU

Long Text

Multiple lines of text. Great for notes, descriptions, comments.

Validation: Supports markdown formatting
Examples: Description, Notes, Comments

Email

Validates email addresses and provides mailto links.

Validation: Must be valid email format
Examples: user@example.com, contact@bases.sh

URL

Web addresses that are validated and clickable.

Validation: Must be valid URL format
Examples: https://bases.sh, https://example.com

Phone Number

Stores and validates phone numbers.

Validation: International format supported
Examples: +1 555-0123, (555) 555-5555

Numbers

Number

Integer or decimal numbers.

Validation: Precision and range can be configured
Examples: 42, 3.14159, -100

Currency

Monetary values with currency symbols.

Validation: Configurable currency and decimal places
Examples: $99.99, €50.00, ¥1000

Percentage

Numbers displayed as percentages.

Validation: Can be 0-100 or 0-1 based on configuration
Examples: 75%, 3.5%, 100%

Duration

Time durations in various formats.

Validation: Configurable display format
Examples: 2h 30m, 1d 4h, 45 minutes

Date & Time

Date

Calendar dates without time.

Validation: Date format can be customized
Examples: 2024-01-15, Jan 15, 2024

Date & Time

Dates with specific times.

Validation: Timezone aware
Examples: 2024-01-15 14:30, 1/15/2024 2:30 PM

Created Time

Automatically records when a record was created.

Validation: Read-only, set automatically
Examples: 2024-01-15 10:23:45

Last Modified Time

Automatically updates when a record is modified.

Validation: Read-only, updates automatically
Examples: 2024-01-16 15:42:18

Selection

Single Select

Choose one option from a predefined list.

Validation: Options must be predefined
Examples: High, Medium, Low

Multi Select

Choose multiple options from a predefined list.

Validation: Options must be predefined
Examples: Tag1, Tag2, React, TypeScript

Checkbox

Boolean true/false value.

Validation: Either checked or unchecked
Examples: ☑, ☐

Rating

Visual star or numeric rating.

Validation: Max rating can be configured
Examples: ★★★★☆, 4/5

User & Collaboration

User

Reference to a user in your workspace.

Validation: Must be valid workspace user
Examples: @john, @sarah

Created By

Automatically records who created the record.

Validation: Read-only, set automatically
Examples: @john

Last Modified By

Automatically records who last modified the record.

Validation: Read-only, updates automatically
Examples: @sarah

Attachments

Attachments

Upload and store files, images, and documents.

Validation: File size and type limits apply
Examples: document.pdf, image.png, data.csv

Relationships

Linked Records

Link to records in another table.

Validation: Target table must exist
Examples: → Customers, → Projects

Lookup

Pull in fields from linked records.

Validation: Requires a linked record field
Examples: Customer Email, Project Status

Rollup

Calculate aggregates from linked records.

Validation: Requires a linked record field
Examples: SUM(Amount), COUNT(Tasks), AVG(Rating)

Advanced

Formula

Calculate values using a formula.

Validation: Formula syntax must be valid
Examples: {Price} * {Quantity}, IF({Status} = "Done", "✓", "○")

Count

Count linked records.

Validation: Requires a linked record field
Examples: 5 tasks, 12 items

Autonumber

Automatically incrementing numbers.

Validation: Read-only, increments automatically
Examples: #001, #002, #003

Barcode

Generate and scan barcodes.

Validation: Various barcode formats supported
Examples: UPC, QR Code, Code 128

Button

Trigger actions or open URLs.

Validation: Action must be configured
Examples: Open URL, Run Script, Send Email

Need Help?

Still have questions about field types? We're here to help: