Forum Discussion
MarkShnier__You Qrew Legend
Qrew Legend
5 years agotry this
"<a class=\"Vibrant Primary\" style=\"width:310px; text-align: center;\" href=\"/db/"&"(MY OTHER TABLE ID INSERTED HERE)"&"?a=sendsubscription&id=1\">SEND REPORT</a>"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
"<a class=\"Vibrant Primary\" style=\"width:310px; text-align: center;\" href=\"/db/"&"(MY OTHER TABLE ID INSERTED HERE)"&"?a=sendsubscription&id=1\">SEND REPORT</a>"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- JeffElliott5 years agoQrew MemberDear Mark:
 That worked like a charm! Any advice on how to have the same button send a 2nd, separate report?
 Jeff
 ------------------------------
 Jeff Elliott
 ------------------------------- MarkShnier__You5 years agoQrew Legend Not tested but try this as a new field of type formula URL (not Formula Rich Text).
 var text SendSubOne = URLRoot() & "db/" & [_DBID_ MY OTHER TABLE ID INSERTED HERE]
 & "?a=sendsubscription&id=1";
 var text SendSubTwo = URLRoot() & "db/" & [_DBID_ MY OTHER TABLE ID INSERTED HERE]
 & "?a=sendsubscription&id=2";
 $SendSubOne
 & "&rdr=" & URLEncode($SendSubTwo)
 I would just make this as URL formula field type instead of a Formula Rich text field as then you do not need the difficult syntax.
 ------------------------------
 Mark Shnier (YQC)
 Quick Base Solution Provider
 Your Quick Base Coach
 http://QuickBaseCoach.com
 mark.shnier@gmail.com
 ------------------------------- JeffElliott5 years agoQrew MemberWorked great! thanks Mark, Jeff.
 ------------------------------
 Jeff Elliott
 ------------------------------