Embed Child Table Report in a Formula Rich Text Field
Has anyone ever embedded a child table report in a formula rich text field? I only need the column headers and data.
Forum Discussion
- Hi Gil,
Is there some specific feature of the child table report you would need that would be distinct from creating a report link of the child table records on the form? - Hi Evan,
I'm combining several rich text fields into a single formula rich text field and within the final formula rich text field, I need to add the child table records. Eventually the final field will be part of an output document. - Hi Gil,
Ahh ok so the end result would be several fields of Rich Text all concatenated together with a report of all the child records also included. I'm not familiar with a good native call to draw that all into one Rich Text field. It may be possible to use API_GenTableResults and some javascripting or IOL to get that all to come together but I've never built anything out like that unfortunately.- No worries. Thanks for checking. That's why I'm putting several Rich Text fields into one. Makes it easier for troubleshooting and customizing.
- What 'output document' method are you going to use?
Most of the tools used for this can allow for a custom formatted child table.- All of this will end up in a Word document. I'm trying to attempt a work around to exact forms since we must use tokens and cannot pay for an external vendor.
