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 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( @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". 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.
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.