Skip to main content
Question

URL api button in the summary report

  • June 9, 2021
  • 0 replies
  • 44 views
Hi,

I have "Bills" (child) table and "Customers" (parent) table.
Each Customer has many Bills.
The Summary report of the "Bills" table, summarized by amount and grouped by Customer's name.
Also I have "Tax type" multi choice field in "Estimates" table.
Tax types can have many customers.
Each "Bill" populate "Tax type" from "Customer" table using Customer ID.

I would like to have a button in the Summary report, witch will open "Customers "Tax type"  form in pop-up window and will allowed to change the "Tax type" in the "Customer" table.

ThUAll


------------------------------
Andrew S
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • June 9, 2021
It sounds mostly possible. Try this as a Rich Text formula field.  It will open in a new tab, not a pop up though.

var text URL = URLRoot() & "db/" & [_DBID_CUSTOMERS] & "?a=er&rid=" & [Related Customer];

var text Words = "Edit Tax";

"<a class='Vibrant Success'" & " a href=" & $URL & " target=_blank" & ">" & $Words & "</a>"

------------------------------
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