Forum Discussion
- _anomDiebolt_Qrew EliteRich Text formula field:
"<a class='Vibrant Success' href='https://login.quickbase.com/db/6ewwzuuj?a=q&qid=6'>Formula Functions Reference</a> - YehudahGreenberQrew Assistant CaptainThank 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?
- _anomDiebolt_Qrew EliteI 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
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).
?a=s
&query={7.TV.1}
&opts=disprec
This will redirect to a URL with a temporary query id like this:https://haversineconsulting.quickbase.com/db/bnfx9yayg
?a=q
&qid=-1000001
- YehudahGreenberQrew Assistant CaptainAmazing, 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.)
- FrancescoSpiga1Qrew CadetFYI - The ReportLink shows exactly the URL path for the specific query.