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 ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIt 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
------------------------------
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
------------------------------
- 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
------------------------------- So, I used alias instead of table name, but it still doesn't work.
My key field in the "Customers" table is "Id" and it reference field in the Bills is "Customer ID"
So I have this request: https://builderprogram-jrynders.quickbase.com/db/brg4q76gd?a=er&rid=3673
And this result:
------------------------------
Andrew S
------------------------------- MarkShnier__YouCan I see a copy and paste of your formula
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- var text URL = URLRoot() & "db/" & [_DBID_TABLE_2] & "?a=er&rid=" & [Customer ID];
var text Words = "Edit Tax";
"<a class='Vibrant Success'" & " a href=" & $URL & " target=_blank" & ">" & $Words & "</a>"
------------------------------
Andrew S
------------------------------
