Forum Discussion

CurtisMiddleto1's avatar
CurtisMiddleto1
Qrew Cadet
2 months ago

Embedding Report Link in Rich Text Field

Hi,

I have an embedded report and each record on the report has a bunch of children records that feed up to it's total dollar amount. That dollar amount is represented as a rich text field. I want the number to be a clickable hyperlink that pulls up the Related Records.

This Related Records field name is "Monthly Accounting Review - CM - Related Actuals Records."

I've referenced this field in the rich text field via this:

"<a href="&[Monthly Accounting Review - CM - Related Actuals Records]&">"&$SummaryNumber&"</a>"

This does the job in making the number a hyperlink. But the problem I'm running into is that the link is now operating differently in the rich text field than how it does as it's own field.

Here is the report view:

But here are the URLs I get for them (top link is the rich text field and the bottom link is the report link field):

Thanks in advance for any help on this!

formulas
  • CurtisMiddleto1's avatar
    CurtisMiddleto1
    Qrew Cadet
    2 months ago

    After further testing, I created a field to just see if I could display the link via ToText([Report Link Field]) and it is displaying blank. This is indicating to me that I might not be able to pass a report link field into a rich text field. Curious if others have experienced something similar?

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 months ago

    You can definitely make the hyperlink display a rport of the children.

    This post here should answer you question as how to make the URL potion of the hyperlink.

    https://community.quickbase.com/discussions/quickbase-discussions/go-to-report-with-custom-filters-formula-url-or-report-link/19851