Multiple history tables / records in one Skuid table?

  • 1
  • Question
  • Updated 2 years ago
  • Answered
I'd like to have the history of tracked field changes from an Account record and the related Contact, Case, and Opportunity records all appear in one table on an Account page, sorted in descending order of the date of the change.

What is the best way to do this?

Thanks!
Photo of Andy Forbes

Andy Forbes

  • 322 Points 250 badge 2x thumb

Posted 4 years ago

  • 1
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
There is not going to be a declarative way to do this - because history is not a single object.  Each object's history is a separate object.  The Skuid table component can only be bound to a single model (single object). 

But you could bring in all the history objects as separate models on your page, and then group them together into a separate model that was built on the fly.  This is going to take some Javscript to do, but....

Building a model on the fly:  http://help.skuidify.com/m/11720/l/228794-dynamic-creation-of-models-and-components-with-javascript
Move the data from existing models to the new model:  Reuse concepts here: http://help.skuidify.com/m/components/l/109496-mass-create-records

Have fun and let us know how it goes...
Photo of Andy Forbes

Andy Forbes

  • 322 Points 250 badge 2x thumb
Thanks!
Photo of Jaime

Jaime

  • 1,220 Points 1k badge 2x thumb
@andy did you ever do this?