Formulas
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 and properties (eg. CREATED_BY) 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
concat( @number, @field)
E.g.
concat( string( @quantity), string( @unit) )
Mixed
Concatenate multiple fields in a formula expression.
Convert the field to a string using string() if the field types are different.
lookup( @referenceField , "Field name")
lookup( @referenceField , "Property")
Entity
Looking up a field in another entity via a reference field.
Note that the field name you want to look up must be in quotation marks, e.g. "String".
You can look up a multi-value field via a single-value reference — all values will be displayed.
dateAdd( @dateField, number, "unit")
E.g. dateAdd( @dateField, 2, "years")
Date
Function to add time periods to date fields.
Supported units: 'days', 'months', 'years'
convertToDatetimeField( @datetimeField)
E.g. convertToDatetimeField(@datetimeField1 - @datetimeField2)
Time & date
Function to convert a unix timestamp to a Time & date field.
formatDatetime(@datetimeField, "format string", "timezone")
E.g.
formatDatetime(@datetimeField, "yyyy-MM-dd HH:mm", "America/New_York")
OR
formatDatetime(@dateField, "format string")
E.g.
formatDatetime(@dateField, "MM-dd-yyyy")
Time & date/Date
Function to format a Time & date or Date field into a string.
Date fields do not have the additional timezone section whereas Time & date fields must have it.
The format string must adhere to the rules set out in adjusting format
Refer to the Timezone supportsection for more information about the timezone string.
?
E.g. (@Field > 3 ? "Large" : "Small"
Mixed
if statements (conditional logic)
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.
Timezone support
Our platform provides flexible timezone handling by supporting three types of identifiers:
IANA names
Timezone abbreviations
Fixed-offset
Etc/GMTcodes
IANA Timezone Names
Using a standard IANA name pins a location to a specific region, the platform will automatically handle changes for Daylight Saving Time, so timestamps are always correct for that location throughout the year.
For a complete list, you can visit this comprehensive list of tz database time zones.
Fixed UTC Offset Timezones
If you require a timezone with a static UTC offset that does not change during the year, you can use either a timezone abbreviation or an Etc/GMT code.
Be aware that many abbreviations are ambiguous. While some abbreviations can be ambiguous (e.g. CST can have multiple meanings globally), our platform uses the specific UTC offsets defined in the table below. Please refer to this list to confirm which offset corresponds to each abbreviation.
The Etc/GMT format is a more explicit way to define a fixed offset.
Important Note: The Etc/GMT notation uses a POSIX-style sign, which is the reverse of what is commonly expected.
Etc/GMT-Xcorresponds to UTC+X. For example,Etc/GMT-10is 10 hours ahead of UTC.Etc/GMT+Xcorresponds to UTC-X. For example,Etc/GMT+5is 5 hours behind UTC.
Last updated