Discussions

Expand all | Collapse all

Button for Report Link

  • 1.  Button for Report Link

    Posted 01-29-2018 21:15
    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?


  • 2.  RE: Button for Report Link

    Top
    Contributor
    Posted 02-06-2018 15:36
    Rich Text formula field:

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


  • 3.  RE: Button for Report Link

    Posted 02-06-2018 16:15
    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?


  • 4.  RE: Button for Report Link

    Top
    Contributor
    Posted 02-06-2018 16:56
    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



  • 5.  RE: Button for Report Link

    Posted 02-06-2018 19:13
    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.)


  • 6.  RE: Button for Report Link

    Posted 01-10-2019 06:11
    FYI -  The ReportLink shows exactly the URL path for the specific query.