Grandparent Form Record Linking
Hi everyone, For everyone US based Happy Thanksgiving! Up early and trying to knock out a few things on the long To Do list while it is quiet :) One situation I have is linking (navigation) bac...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp,
you can make a hyperlink to go anywhere, just like any hyperlink anywhere on the internet.
var text Words = [Project Name];
var text URL = URLRoot() & "db/" & [_DBID_PROJECTS] & "?a=dr&rid=" & [Record ID# of Project]
// this last part is always the same
"<a href=" & $URL & ">" & $Words & "</a>"
Get the table name alias for [_DBID_PROJECTS] PROJECTS from the Advanced Properties page. Get the Record ID of the Project from a lookup of [Related Project] from Opportunities. But don't call it [Related Project] as it's not related. Call it what it is, [Record ID# of Project].
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
you can make a hyperlink to go anywhere, just like any hyperlink anywhere on the internet.
var text Words = [Project Name];
var text URL = URLRoot() & "db/" & [_DBID_PROJECTS] & "?a=dr&rid=" & [Record ID# of Project]
// this last part is always the same
"<a href=" & $URL & ">" & $Words & "</a>"
Get the table name alias for [_DBID_PROJECTS] PROJECTS from the Advanced Properties page. Get the Record ID of the Project from a lookup of [Related Project] from Opportunities. But don't call it [Related Project] as it's not related. Call it what it is, [Record ID# of Project].
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- I had this email sitting in my box and realized I never responded! Hate leaving something unresponded, my apologies. This worked beautifully!
------------------------------
Ivan Weiss
------------------------------
