WebsiteGet StartedContact Us

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

What can I compute with formula fields?

Seal's formula fields cover a wide range of functionality, from simple calculations to complex computing.

The underlying library handling the calculations is Math.js. See the table below for examples of common operators and how to use them in your formulas.

For a full list, please refer to the Math.js library, or speak to our team.

Formula Language
Data type
Description

+ — / *

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.

? 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.

Last updated