Model Child Relationships - Multiple Instances

  • 1
  • Idea
  • Updated 1 year ago
I need to do rollup values from the standard Task object to my custom Project object. Apparently the Declarative Lookup Rollup Summary doesn't work with recurring tasks.



So now I'd like to use the Child Relationship multiple times with differing conditions in order to get Task Counts for each scenario. ie. Overdue Tasks, Total Hours Completed (rollup on custom field), etc.

I'd have to make use of a snippet to do anything other than a count, but no big deal.

I'm figuring that this something that isn't possible with Salesforce SOQL. :/

I don't otherwise have a solution, unless I go to custom apex, which I'd clearly like to avoid.

Anybody have an idea?
Photo of mB Pat Vachon

mB Pat Vachon, Champion

  • 42,714 Points 20k badge 2x thumb

Posted 2 years ago

  • 1
Photo of mB Pat Vachon

mB Pat Vachon, Champion

  • 42,714 Points 20k badge 2x thumb
K. I have a solution but it's not perfect.

Add Task Aggregate model.

Create Read-Only UI only fields on Project object and use snippets to get values from Agg model using record id to find values.
Photo of Jack Sanford

Jack Sanford, Champion

  • 8,322 Points 5k badge 2x thumb
You could also use ModelLookup function in UI-only fields on Project Object, see Rob's response here: https://community.skuid.com/skuid/topics/multiple-child-records-on-a-model