Morning Tadabasers!
I need to produce reports based on three different layouts: Layout-1, Layout-2, Layout-3.
We have three different top level tables where I can add reports, each linked to its own details page. The details page holds the layout and Data Components which form the report.
I don’t want to have three different details pages linked from a single table, as the number of Layouts will grow and we won’t have enough columns to link to them.
My question is this: how can I have a single Reports table with all reports showing in that one?
It seems I could use a table (or page) rule to duplicate any new rows into this overall Reports table?
But what I really want to do is kind of the opposite - to have a single table where I can add a new report based on either Layout-1, Layout-2, Layout-3.
A dropdown would allow me to select which Layout I want, but then the following would need to happen:
a) a record be created in the ‘other’ table (the one attached to either Layout-1, Layout-2, Layout-3 details page)
b) a link be created allowing access to the record created by a)
a) could be handled by a rule, as before
b) sounds like a rule again but I am not sure about the use of formula fields etc in rules?
I suppose you could say my task is the need to have a table column, dynamically populated with a link to a details page that is attached to a different table but shares common data.
Thanks for any input!
Danny