Embed Child Table Report in a Formula Rich Text Field

  • 0
  • 1
  • Question
  • Updated 1 year 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

  • 950 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 12,028 Points 10k 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

  • 950 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

  • 12,028 Points 10k 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

  • 950 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,698 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

  • 950 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.