What's new ·
Calculated fields and sums of connected records in tables
Create columns that calculate themselves from other columns or connected records, such as the total of a product cart.
By Lucas Marchon, Founder at BrainChat
An order total, the number of items in a contract, a supplier's average rating. These numbers don't need to be typed manually: the calculated field does the math.
How it works
The calculated field does not store data: the value is computed on the fly from other columns or connected records.
| Operation | Example |
|---|---|
| Sum | Total value of products in a deal |
| Count | How many tickets the customer has opened |
| Average | Average rating of a supplier |
Quantity and discount
Enter the quantity of each connected item and apply a discount by percentage or fixed amount. In the example above: 2 × R$ 50 + R$ 120, minus 10%, equals R$ 198.
In dashboards
Calculated fields are available in Studio widgets just like any other column.
Released previously
- New fields in tables: User, Image and card connections: connections displayed as cards.
- Tables: expression assistant, saved filters and linked records: formulas with an assistant.