Formula Fields
Formula fields calculate values from other data, such as an item's fields, records in a connected data source, or other formulas. These fields allow you to extract, format, or manipulate data using any of the formulas available in Tonkean.
Tonkean offers three types of formula fields. Each type calculates and refreshes its value differently, so choose the type based on how you plan to use the result:
Formula type | Use it to | Refreshes |
|---|---|---|
Calculate a value for a single item using that item's fields, such as combining "First Name" and "Last Name" fields into a "Full Name" field. The result behaves like any other field, so you can use it in conditions, automations, filtering, sorting, reporting, and other formulas. | When a field it depends on changes | |
Summarize or calculate values across multiple related records in a connected data source, such as counting the open invoices for a supplier. | Periodically | |
Display dynamic, localizable text in widgets and communications, such as helper text or a sentence that includes field values. UI-only formulas can't be used in conditions or referenced by workflow formulas. | Each time the interface loads |
You can create all three types of formula fields from the Formulas section of the Fields panel in the module builder. For a quick reminder of when to use each type, select Usage Guide in the Formulas section.