We've upgraded Stacker Formulas, Lookups and Rollups so that they can now all be used together. In the past it was impossible to reference a formula in another formula, or to use the value from a rollup in a lookup, or to rollup a formula field... or any other combination.
Stacker now supports all of these combinations.
This enables some key benefits:
- Formulas to reference other formulas- this allows the encapsulation of logic so you can break your formulas down to simpler expressions that build on each other.
- Rollups of formulas- for example if line items on an invoice have a formula that calculates the amount of tax on them, the total tax can be rolled up to the invoice by rolling up this tax formula.
- Lookups to formulas- bring a calculated value from one table onto another table to use it there.
- And many more combinations - the aim is that when you're building your app you don't have to worry if you are going to be able to use your field in a formulas, lookups or rollups, because they will always work.
This feature is now available in
Stacker V5 (Astra)
, which is currently in Private Beta and will launch generally later this year. If you'd like to try it out, then get in touch.