Skip to main content
Question

Report Link Field, displaying different field

  • December 3, 2020
  • 0 replies
  • 97 views
JimHarrison
Forum|alt.badge.img+16
I think this is a known but haven't been able to find anything online yet.

We have a Report Link field (not in a relationship) that displays records from another table. In this example the Report Link matches off the Year field present in both tables. We want to display the number of records found and not the Year field used to find matching records. When the report link field is added to a report it shows the Year as the link to the records. When the Report Link field is displayed on a form as a Report, the count is correct, so the data is there. How to display the number of records found, the count and not the Year?

There are no options in the Report Link properties allowing a developer to pick which field is displayed.

If this makes sense, is there an alternative solution we are not using?

I'm thinking about investigating using a Rich Text formula with the Report Link to style the Report Link array if that is possible but I doubt it.
Also thinking about displaying the form as a report on a page.

Thoughts?

------------------------------
Jim Harrison
------------------------------

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • December 3, 2020
Do you want to get summary totals the only way to do that at this time is to create a relationship and do a summary field. There was talk at EMPOWER about improvements to the formula language which will allow us to do a query right in formula field but that does not yet exist. 

The alternative is to embed a summary report on your form which will show just a summary count on a one line summary report. You may need to use a dummy field to summarize on so all records summarized onto one line of the report.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Forum|alt.badge.img+14
  • MichaelTamoush
  • Quickbase Alumni
  • December 3, 2020
I've had this same issue. For me, even though there was no relationship, somewhere, somehow along the way I was able to get that number, and pass it all around through lookup fields until it got to the table I wanted. A lot of times it can be a bit tricky, but sometimes if you dive deep enough you find a way....and it involves a maze of summary and lookup fields....


------------------------------
Mike Tamoush
------------------------------
    Terms & ConditionsAccessibility statement