Formulas
Last updated
Last updated
Formula fields in Seal enable you to perform calculations across an entity's fields.
Use the @ symbol in the formula input to see the fields available to use in the formula expression.
Formula expressions can include the following fields:
Number
Text
Select
Time & date
Reference
Checkbox
Formula
+
—
/
*
Number
Addition, subtraction, division, multiplication
==
Number
Equal to
!=
Number
Not equal to
lookup( @Reference , "Field name")
lookup( @Reference , "Property")
Entity
Looking up a field in another entity.
Note that the field name you want to look up must be in quotation marks, e.g. "String"
.
dateAdd( @dateField, number, "unit")
E.g. dateAdd( @dateField, 2, "years")
Date
Function to add time periods to date fields.
Supported units: 'days'
, 'months'
, 'years'
@Fieldname == null ? <if value does not exist> : <if value exist>
Any field data type allowed in formulas
To return a value conditionally based on the field value.
Formulas calculate in real time, so you can instantly verify the expression returns your desired result.
Error messages are show in red text in the formula preview box.
Warning messages are shown in yellow below the preview box.
For a full list, please refer to the library, or speak to our team.
You can look up a multi-value field via a single-value reference — all values will be displayed.
Note that you can also look up properties from the current entity by typing in the $
symbol.