Discussions

Expand all | Collapse all

Making a Link in a report look like a button

  • 1.  Making a Link in a report look like a button

    Posted 21 days ago
    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.                                                                         
    Current look of report


    ------------------------------
    Chris Swirtz
    ------------------------------


  • 2.  RE: Making a Link in a report look like a button

    Posted 21 days ago
    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
    ------------------------------



  • 3.  RE: Making a Link in a report look like a button

    Posted 21 days ago
    Mark,

    It's a report link field

    ------------------------------
    Chris Swirtz
    ------------------------------



  • 4.  RE: Making a Link in a report look like a button

    Posted 21 days ago
    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
    ------------------------------



  • 5.  RE: Making a Link in a report look like a button

    Posted 21 days ago
    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
    ------------------------------