Forum Discussion

AndrewS's avatar
AndrewS
Qrew Trainee
4 years ago

URL api button in the summary report

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
------------------------------
APIs and custom code
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew 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's avatar
      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's avatar
      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's avatar
      AndrewS
      Qrew Trainee
      4 years ago





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