Fields in SomaDB

Fields are the building blocks of your SomaDB tables. They define what type of data can be stored and how it's displayed and manipulated.

Field Types Overview

SomaDB supports a wide variety of field types to handle different kinds of data:

Text-Based Fields

• Single Line Text
• Long Text
• Rich Text
• Email
• Phone Number
• URL

Numerical Fields

• Number
• Decimal
• Percent
• Currency

Select-Based Fields

• Single Select
• Multi Select

Links-Based Fields

• Links
• Lookup
• Rollup

Custom Types

• Attachment
• Button
• Checkbox
• Rating
• QR Code
• Barcode
• Geometry
• JSON

Formula Fields

• Formula
• Numeric & Logical Operators
• Numeric Functions
• String Functions
• Date Functions
• Array Functions
• Conditional Expressions
• Generic Functions
• JSON Functions
• Formatting Formula Results

Date Time Based Fields

• Date Time
• Date
• Time
• Duration
• Created Time
• Last Modified Time

User-Based Fields

• User
• Created By
• Last Modified By

Field Management

• Primary Key - Understanding primary keys
• Display Value - How fields are displayed
• Multi-field Editor - Edit multiple fields at once
• Field Summary - Overview of all fields
• Actions On Field - Field management actions

Explore Field Types

Choose a category above to learn more about specific field types and how to use them effectively in your SomaDB bases.