Forum Discussion

Re: Making a Link in a report look like a button

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
------------------------------
No RepliesBe the first to reply