Skip to main content
Question

Modifying Report Link behavior

  • January 28, 2020
  • 0 replies
  • 42 views
Currently, when clicking on a report link that has more than 1 child record, the result is the default report for the child table showing the child records allowing for grid editing. However, if there is only 1 child record available, the link takes you to the form of the record itself instead of the report view. Is there a way for the link to always go to the report view whether there is 1 or 100 child records attached?

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

Forum|alt.badge.img+15
  • DonLarson
  • Registered
  • January 29, 2020
Chris,

Instead of a Report Link  build a custom URL that will take you to the report you want.

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=XX&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