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.

Sum of connected products with quantity and discount

How it works

The calculated field does not store data: the value is computed on the fly from other columns or connected records.

OperationExample
SumTotal value of products in a deal
CountHow many tickets the customer has opened
AverageAverage 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

Related

Explore the feature: Tables

See all posts