Button for Report Link

  • 0
  • 2
  • Question
  • Updated 9 months ago
  • Answered
Hello everyone.  Is there a way to display a Report Link as a clickable button, as opposed to simply the "link text" available in field settings?
Photo of Yehudah Greenberg

Yehudah Greenberg

  • 600 Points 500 badge 2x thumb

Posted 10 months ago

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

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,522 Points 20k badge 2x thumb
Rich Text formula field:

"<a class='Vibrant Success' href='https://login.quickbase.com/db/6ewwzuuj?a=q&qid=6'>Formula Functions Reference</a>"
Photo of Yehudah Greenberg

Yehudah Greenberg

  • 600 Points 500 badge 2x thumb
Thank you Dan for responding, but I don't understand this solution.  The above link brings the user to existing reports, which are accessible by designating "qid=" as 6, 7, etc.  How does this solution translate to a report link field, which (I think) generates a temporary report when the link is clicked?
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,522 Points 20k badge 2x thumb
I wasn't reading that correctly. But you can emulate the same URL QuickBase uses for the report link by writing the query yourself and adding the disprec parameter:
"<a class='Vibrant Success' href='https://haversineconsulting.quickbase.com/db/bnfx9yayg?a=s&query={7.TV."; & [Record ID#] & "}&opts=disprec'>Report Link</a>"
For [Recod ID#]=1 the query is this:
https://haversineconsulting.quickbase.com/db/bnfx9yayg
?a=s
&query={7.TV.1}
&opts=disprec
Your guess is as good as mine but I think the action a=s mean show (conceptually similar to view but different for some reason).

This will redirect to a URL with a temporary query id like this:
https://haversineconsulting.quickbase.com/db/bnfx9yayg
?a=q
&qid=-1000001

(Edited)
Photo of Yehudah Greenberg

Yehudah Greenberg

  • 600 Points 500 badge 2x thumb
Amazing, thank you!  (I cut and pasted from your post and I think that there might be a slight syntax problem, so I worked off of my own debugger.)