Skuid Rollup summaries with UI-only formula fields

I have to give Pat Vachon (mBlazonry) a lot of credit for coming up with this awesome and stupidly easy-to-implement idea!
By adding a UI-only formula field to a parent model and using the syntax below in the UI formula builder...you can calculate and display rollup summaries.
{{CustomObject__r.totalSize}}
Notes:
# of Goals in Progress is a UI-Only Formula Field in a
table with drawers that open up to display the specific goals
By adding a UI-only formula field to a parent model and using the syntax below in the UI formula builder...you can calculate and display rollup summaries.
{{CustomObject__r.totalSize}}
Notes:
- Just be sure to add the child relationship to your model within the model's fields section.
- No Master-Detail relationship needed (lookups relationships are fine)
- No third-party app needed like DLRS (declarative rollup summaries) or Rollup Helper
- Usable directly in a basic model on field editors, tables, templates, page titles...no need to build a separate aggregate model
- Granted...this is a UI-only field, so the summary isn't saved to the object, but you could easily solve that with an action sequence that would 1) update a SF field with the UI-only value and 2) save down the value
- Super quick and easy to implement

# of Goals in Progress is a UI-Only Formula Field in a
table with drawers that open up to display the specific goals
Tagged:
5
Categories
- 7.9K Questions
- 926 Ideas
- 220 Discussion Categories
- 178 General
- 9 Community Feedback
- 3 Community Info
- 18 Knowledge Base
Comments
Just be sure to the child relationship name and the not the object name.
Additionally, using "Fields to Order Records By" and "Max # of Records (Limit)" set to 1, then one can also achieve Min or Max on Dates and Numbers.
{{{{Transaction_Line_Items__r.records.0.FIELDCHOICEHERE}}
You can use an aggregate model to get the sum of Amount by the picklist value. Then add a Model UI Only field to the model where you want the sum to appear. Setup this UI Only field as a Formula field and use the Model Lookup feature to find the matching sum for the picklist value.
Thanks,
Bill
{{Tasks__r.records.0.ActivityDate}}