Home

Create New Derived Field

Back to List
Create Powerful Calculated Fields

Derived fields enable complex calculations using existing data. Use them for tax calculations, discounts, data transformations, and business metrics.

Field Explorer
Input Fields 0
  • Select a model to view fields
Derived Fields 0
  • Loading...
Summary Fields 0
  • Loading...
Math Functions 10
  • round() Round to nearest
  • sum() Sum of values
  • avg() Average
  • min() Minimum
  • max() Maximum
  • abs() Absolute value
  • floor() Round down
  • ceil() Round up
  • pow() Power
  • sqrt() Square root
Math Operators
+
-
*
/
%
(
)
<
>
=
Basic Information
Unique name used to reference this field
The table where this field will be calculated
Data type of the computed result
Type of expression language to use
Specify where this field is available for use
Expression
Enter your expression here. Format depends on the selected expression type.
Calculation Preview
expression = result
Expression Dependencies

Dependencies will be visualized here as you build your expression

Dependencies
Dependencies will be automatically extracted from your expression when possible. You can also manually specify them below.
Table Joins
Joins allow you to access data from related tables in your expressions.
Field Registry Integration
Auto-Sync Enabled

This field will be automatically registered in the Field Registry upon saving. The registry tracks:

  • Field capabilities (filterable, computable, gridable)
  • Field lifecycle (active, deprecated, archived)
  • Display metadata and categorization
  • Integration with templates and evolved records
Display & UI Options
Leave empty to auto-generate from field name