Embed Child Table Report in a Formula Rich Text Field

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • In Progress
Has anyone ever embedded a child table report in a formula rich text field? I only need the column headers and data.
Photo of Gil Spigelman

Gil Spigelman

  • 870 Points 500 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 8,774 Points 5k badge 2x thumb
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?
Photo of Gil Spigelman

Gil Spigelman

  • 870 Points 500 badge 2x thumb
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.
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 8,774 Points 5k badge 2x thumb
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. 
Photo of Gil Spigelman

Gil Spigelman

  • 870 Points 500 badge 2x thumb
No worries. Thanks for checking. That's why I'm putting several Rich Text fields into one. Makes it easier for troubleshooting and customizing.
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
What 'output document' method are you going to use?

Most of the tools used for this can allow for a custom formatted child table.
Photo of Gil Spigelman

Gil Spigelman

  • 870 Points 500 badge 2x thumb
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.