What's new ·
Tables: expression assistant, saved filters and linked records
Formulas with assistant, column behavior, saved views, and related record lists with totals.
By Lucas Marchon, Founder at BrainChat
Advanced spreadsheets have turned into systems in many companies due to three things: formulas, column rules, and saved views. BrainChat tables have gained all three.
Expressions with assistant
Build formulas with columns and functions at hand, without memorizing syntax. The calculated column can be displayed as the result type: currency, date, link with logo.
Column behavior
| Rule | Example |
|---|---|
| Initial value | Today's date upon creation |
| Show when | "Reason" field only if status is Lost |
| Edit when | Value locked after approval |
| Required when | Tax ID required for legal entities |
| Valid when | Discount up to 15% |
Saved views
Filters and sorting saved by name, to return to the same view with one click. Selection options can be created from the values that already exist in the column.
Related records
View linked records on both sides of the connection, in cards or table, with count and totals. Example: in the customer, the list of orders with the sum of the values.
Also in this update
Invite access for people from other channels, pagination, and favorites.
Complements
- Calculated fields and sums of connected records in tables: the first calculated fields.
- Tables and Flow: write API, batch registration, and large lists: expressions also in Flow steps.