Share
ReportHello everyone!
I'm in a situation where I need a "Task" table (which represents work that needs to be done before a specific date) that will be related to various other custom tables in a tree configuration. All the tables involved are custom (no Account, Contact, Opportunity, etc...), and I have various levels of relationship depth.
Take for example this table structure:
MainCustomTable -> CustomTableA -> CustomTableAA
-> CustomTableB
-> CustomTableC -> CustomTableCA -> CustomTableCAA
-> CustomTableCB
-> CustomTableD -> CustomTableDA
-> CustomTableDB -> CustomTableDBA -> CustomTableDBAA
-> CustomTableDBAB
Every table in this tree should have its own "Tasks", but I also need a way to see at the "MainCustomTable"-level all the "Tasks" for every child or sub-child (or sub-sub-child, etc...) in a single view. This "MainCustomTable"-level component could also be a simple SubGrid; it doesn't have to be necessarily a Timeline view.
My idea is to have a new column for the "Task" entity, and then add a plugin that sets this new column when a Task is created or updated, containing a reference to the "MainCustomTable" record, fetched following the dynamic path from the specific custom table back to "MainCustomTable".
So, first of all, do you have any suggestions regarding this design?
Second, if you had to implement this design, would you use the standard "Task" table and add a column + plugin, or would you use a separate custom activity table?
Thank you very much,
Davide
All responses (
Answers (
545
