Skip to main content
Question

Making a Link in a report look like a button

  • January 27, 2020
  • 0 replies
  • 40 views
I know there is a way to make link text in a report show up as a button instead but I can't for the life of me remember what it looks like. Please help!

In the attached example, want to make the "Modify Peripherals" link text look like the "Add Peripheral" button next to it.                                                                         


------------------------------
Chris Swirtz
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
What field type is that Modify Peripherals field?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Forum|alt.badge.img+15
  • DonLarson
  • Qrew Cadet
  • January 28, 2020
Chris,

A Report Links functionality can be duplicated by using a QID.

Create a Formula Rich Text Field and use any image that you want to display instead of text.   Build the QID in the target table using <Ask the User> for the fields that you pass into it to make the report.

Here is a quick example where two values from your parent table are used in the report for the target:

// Images
var text IMG  =     "<img src=https://images.quickbase.com/si/48/045-lock.png>"; 

// QID
var text QID =
URLRoot() & "db/" & [_DBID] & "?a=q&qid=12&nv=2&v0=" &[VariableZero] & "&v1="&[VariableOne];

// HTML Execute URL

 "<a href=" & $QID & "' title=\"Pseudo Report Link\">"  & $IMG &  "</a>"

Make sure you change qid=XX to the correct value of the report you made in the target table.
This is more powerful than a Report Link as you can build as complex a QID as you need for the business case.

------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Terms & ConditionsAccessibility statement