multiple child records on a model

  • 1
  • Idea
  • Updated 3 years ago
  • Not Planned
It would be great to add Child Records more than once to a model, so that you could have different Conditions on each instance. Similar to adding aggregations more than once, instead of checking a box, you click on the child record type and it adds it once to the model...
Photo of Jack Sanford

Jack Sanford, Champion

  • 8,322 Points 5k badge 2x thumb

Posted 3 years ago

  • 1
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Yes Jack.  That would be great.   However I think thats going to run into some core SOQL limitations..... 

You could however do this with 2 or more models linked with UI Only formula fields. 

So.... create an account model. 
Then create contact aggregate models that count contacts, group by account,  and filter to only accounts in first model, and some field like "type"
In the account model add model lookup formula fields:   
    MODEL_LOOKUP("ContactModel","CountId","AccountID",{{Id}})

Rinse and repeat on the other type values to get counts of contacts by different types in your account data.   (Bye bye fomula fields....)

You might want to add a model condition to the account model so when it is requeried,  conditions are passed to the contact models and they get requieried.  You know,  keep it all in synch and don't try to download all your records at the same time...

Fun...
(Edited)