DonLarson
6 years agoQrew Elite
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
// QID
var text QID =
URLRoot() & "db/" & [_DBID] & "?a=q&qid=12&nv=2&v0=" &[VariableZero] & "&v1="&[VariableOne];
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
------------------------------
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
------------------------------