Forum Discussion

WalkerMarema1's avatar
WalkerMarema1
Qrew Member
6 years ago

Formula - URL on a Summary Report

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
------------------------------
APIs and custom code
Button
reports and charts
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    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
    ------------------------------