Skip to main content
Question

Button for Report Link

  • January 30, 2018
  • 0 replies
  • 140 views

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?
This topic has been closed for replies.

  • Registered
  • February 6, 2018
Rich Text formula field:

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

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?

  • Registered
  • February 6, 2018
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


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.)

FYI -  The ReportLink shows exactly the URL path for the specific query.