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

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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

If the Key field of the customers table is not the Record ID# field then try thisvar text URL = URLRoot() & "db/" & [_DBID_TABLE_2] & "?a=er&key=" & [Customer ID];var text Words = "Edit Tax";"<a class='Vibrant Success'" & " a href=" & $URL & " target=_blank" & ">" & $Words & "</a>"------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Thank you for fast response Mark,I have "Customer 1" and "Customer 2" table, so this formula use the "Customer 1" by default, how can I change it?------------------------------Andrew S------------------------------

Actually my "Customers" table connected table to the another APP, and formula can't recognize it.------------------------------Andrew S------------------------------

------------------------------Andrew S------------------------------

URL api button in the summary report

14 Replies

MarkShnier__You
Qrew Legend
4 years ago
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
------------------------------
- AndrewS
  Qrew Trainee
  4 years ago
  Thank you for fast response Mark,
  
  I have "Customer 1" and "Customer 2" table, so this formula use the "Customer 1" by default, how can I change it?
  
  ------------------------------
  Andrew S
  ------------------------------
- AndrewS
  Qrew Trainee
  4 years ago
  Actually my "Customers" table connected table to the another APP, and formula can't recognize it.
  
  ------------------------------
  Andrew S
  ------------------------------
- AndrewS
  Qrew Trainee
  4 years ago
  
  ------------------------------
  Andrew S
  ------------------------------

Forum Discussion

URL api button in the summary report