Forum Discussion

ChrisSwirtz2's avatar
ChrisSwirtz2
Qrew Cadet
6 years ago

Making a Link in a report look like a button

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
------------------------------
  • 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
    ------------------------------
    • ChrisSwirtz2's avatar
      ChrisSwirtz2
      Qrew Cadet
      Mark,

      It's a report link field

      ------------------------------
      Chris Swirtz
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        It can be done, but its not so easy to do.  probably not worth the effort.  it's not just a checkbox setting.  If its super important to you, I can probably locate a previous post i did on how to do this.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------
  • 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
    ------------------------------