Button for subscription not sending report
I am using Formula rich text to try and create a button that will send a subscription report that is in a different table in the same app..... However, it is only taking me to the subscription report...
Forum Discussion
Dear Mark:
That worked like a charm! Any advice on how to have the same button send a 2nd, separate report?
Jeff
------------------------------
Jeff Elliott
------------------------------
That worked like a charm! Any advice on how to have the same button send a 2nd, separate report?
Jeff
------------------------------
Jeff Elliott
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendNot 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
------------------------------
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
------------------------------
- Worked great! thanks Mark, Jeff.
------------------------------
Jeff Elliott
------------------------------