Formula Fields in SomaDB

Formula fields allow you to perform calculations, data transformations, and complex operations on your data. These fields automatically calculate values based on other fields and can use a wide range of functions and operators.

Formula Field Types

Formula

• Use Case: Calculations, data transformations
• Features: Custom formulas with functions and operators
• Validation: Formula syntax validation

Numeric & Logical Operators

• Use Case: Mathematical and logical operations
• Features: Basic arithmetic and comparison operators
• Validation: Operator syntax and data types

Numeric Functions

• Use Case: Mathematical calculations
• Features: SUM, AVERAGE, COUNT, and more
• Validation: Numeric data validation

String Functions

• Use Case: Text manipulation and processing
• Features: CONCATENATE, SUBSTRING, and more
• Validation: String data validation

Date Functions

• Use Case: Date and time calculations
• Features: Date arithmetic and formatting
• Validation: Date format validation

Array Functions

• Use Case: List and array operations
• Features: Array manipulation and processing
• Validation: Array data validation

Conditional Expressions

• Use Case: Conditional logic and branching
• Features: IF, CASE, and conditional operators
• Validation: Logical expression validation

Generic Functions

• Use Case: General-purpose operations
• Features: Utility functions and operations
• Validation: Function-specific validation

JSON Functions

• Use Case: JSON data manipulation
• Features: JSON parsing and processing
• Validation: JSON format validation

Formatting Formula Results

• Use Case: Display formatting and presentation
• Features: Number, date, and text formatting
• Validation: Format specification validation

Key Features

• Automatic Calculation: Values update automatically
• Rich Function Library: Extensive function support
• Error Handling: Graceful error handling and validation
• Performance Optimization: Efficient calculation engine

Best Practices

• Keep formulas simple and readable
• Use descriptive field names
• Test formulas thoroughly
• Consider performance with large datasets
• Document complex formulas

Next Steps

Explore each formula category to learn more about specific functions and use cases.