How can I place the results of a Report Link field into a Text Field?

  • 0
  • 1
  • Question
  • Updated 8 months ago
  • In Progress
I have a table of products.  Within the record is a 'Style' field.  Many products share a common 'style'.  

I also have a table called 'Flashcard' where the users select products that are being considered for marketing initiatives.  When they select a single product for inclusion on this table, they also want a list of all the products that have a shared 'style'.  The list is informational only.

I am taking many fields from the Flashcard record and composing them in a Rich Text Formula field that displays text and images - it is within this formula that I want to include the data from the Report Link.

While I can easily show the report link on the Form, I cannot show it on a report. 

Here is a pic of my form:


Here is a pic of my report:



The pic attached here shows the current excel doc layout I am trying to emulate.


Any help is greatly appreciated!
Photo of Elwyn

Elwyn

  • 94 Points 75 badge 2x thumb

Posted 8 months ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,572 Points 20k badge 2x thumb
I am sure this can be done with script but there is some confusion over which fields are in which table.

I assume you have a parent child relationship between Flahscards -< Products although you don;t explicitly state this. Please confirm or clarify.

Your report (the second image) suggests that there are seven sets of fields displayed in a compact "flashcard" format. This is the first of the seven such "flashcards" and like the other six displays at least five pieces of information::



So I would assume that you have at least 7 * 5 fields used in the Flashcard table.

What would help understand you questions is an explicit list of the fields in each table and how they map to your images.
(Edited)