How to go to grand parent record
Hi All, Can some help to navigate to grandparent record in a grandparent-parent-child relationship from a child record Scenario is the below, Consider i have three table GrandParent--> Parent -->...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp,
You can simply create a Hyperlink, just like any hyperlink anywhere on the internet. I always use the same generic format to keep it simple.
var text Words = [field which has an identifier of he Grandparent record which was double hopped down from the Grandparent to the Parent to he child you are on];
var text URL = URLRoot() & "db/" & [_DBID_Table_alias_of_the_Grandparent] & "?a=dr&rid=" & [Record ID#of GrandParent record looked up by a double hop];
// this last part is always the same
"<a href=" & $URL & ">" & $Words & "</a>"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
You can simply create a Hyperlink, just like any hyperlink anywhere on the internet. I always use the same generic format to keep it simple.
var text Words = [field which has an identifier of he Grandparent record which was double hopped down from the Grandparent to the Parent to he child you are on];
var text URL = URLRoot() & "db/" & [_DBID_Table_alias_of_the_Grandparent] & "?a=dr&rid=" & [Record ID#of GrandParent record looked up by a double hop];
// this last part is always the same
"<a href=" & $URL & ">" & $Words & "</a>"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
I am trying to make this work and must be doing something wrong.
The url is displaying as:
http://<a href=https://lightshipgroup.quickbase.com/db/bkusrx5kc?a=dr&rid=252>Andrews Robert</a>
Tables involved: Customers --> Locations --> Generator
This is my formula:
[Customer Name]- [field which has an identifier of he Grandparent record which was double hopped down from the Grandparent to the Parent to he child you are on]
_DBID_COMPLETE_DATABASE - Customers Table (grandparent)
Location - Customer - Record ID#- Record ID hopped down??
Is there anything I am obviously doing wrong or missing here? Maybe I am not understanding the fields I am supposed to substitute?
Thank you,
Amanda
------------------------------
Amanda Torrisi
------------------------------
The url is displaying as:
http://<a href=https://lightshipgroup.quickbase.com/db/bkusrx5kc?a=dr&rid=252>Andrews Robert</a>
Tables involved: Customers --> Locations --> Generator
This is my formula:
var text Words = [Customer Name];
var text URL = URLRoot() & "db/" & [_DBID_COMPLETE_DATABASE] & "?a=dr&rid=" & [Location - Customer - Record ID#];
"<a href=" & $URL & ">" & $Words & "</a>"
[Customer Name]- [field which has an identifier of he Grandparent record which was double hopped down from the Grandparent to the Parent to he child you are on]
_DBID_COMPLETE_DATABASE - Customers Table (grandparent)
Location - Customer - Record ID#- Record ID hopped down??
Is there anything I am obviously doing wrong or missing here? Maybe I am not understanding the fields I am supposed to substitute?
Thank you,
Amanda
------------------------------
Amanda Torrisi
------------------------------
- MarkShnier__YouTry changing the field type to formula Rich Text.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- That worked perfectly. Thanks!
------------------------------
Amanda Torrisi
------------------------------