Skip to main content
Question

Formula - URL on a Summary Report

  • March 2, 2020
  • 0 replies
  • 22 views
Greetings all, 

I was wanting to create a summary report that I thought would be quite simple. 

My workflow is essentially a ticketing system for different types of requests. I'd like to display a summary report of the the most frequently used requests and display a link to create a new record of that type of request which would require a formula url. 

It seems Formula-URL fields can only be summarized on if they are made as a report formula, and even then only the text of the url is displayed, not the link itself. I'd like my users to be able to click directly from the report to create a new record. 

Any thoughts for this?

------------------------------
Walker Marema
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • March 2, 2020
np
just make a formula Rich Text field as a Hyperlink to the Add Record form.

var text Words = "Add " & [Request Type];

var text URL = [URL formula field to add record];

// this last part is always the same

"<a href=" & $URL & ">" & $Words & "</a>"

Then on your summary report, have that as the first Group by

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement