Formula URL to Parent
Greetings, I'm attempting to build a formula URL field that would redirect a user to the parent record. Reason being, the Summary Reports change the behavior of the related field and does not send ...
Forum Discussion
I really appreciate the help and the formulas worked! However, the craziest thing is the Summary Report disregards these links and takes the user to the drill down and not to the parent record. Not sure if there is any way around this.
------------------------------
Lee Gilmore
------------------------------
------------------------------
Lee Gilmore
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendIf you are looking to have a summary report and want to drill into say the left hand column and drill to the parent record and NOT the supporting detail, then you can make a [hyperlink] and use that in place of the [field].
Let's say that your summary report is by Branch and that the key field of the Branch table is Record ID#. maybe the field is called [Branch hyperlink]
var text Words = [Branch];
car text URL = URLRoot() & "db/" & {_DBID_BRANCHES] & ?"a=dr&rid=" & [Related Branch];
"<a href=" & $URL & ">" $Words & "</a>"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Let's say that your summary report is by Branch and that the key field of the Branch table is Record ID#. maybe the field is called [Branch hyperlink]
var text Words = [Branch];
car text URL = URLRoot() & "db/" & {_DBID_BRANCHES] & ?"a=dr&rid=" & [Related Branch];
"<a href=" & $URL & ">" $Words & "</a>"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------