Forum Discussion

PushpakumarGna1's avatar
PushpakumarGna1
Qrew Assistant Captain
6 years ago

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 --> Child

I have created a column "Link to GrandParent" and made as a reference column in the Parent table
If i take this column one step forward to the "Child" table , clicking on this link form the "Child" table will only take me to the "Parent" table . Since there is a not a  established direct relationship with "Child" table , from "GrandParent"

Can you please let me know how can i traverse from Child to Grandparent via parent table.

Thanks
Pushpakumar


------------------------------
Pushpakumar Gnanadurai
------------------------------
Relationships
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    np,
    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
    ------------------------------
    • AmandaTorrisi's avatar
      AmandaTorrisi
      Qrew Trainee
      5 years ago
      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: 

      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>"

      My fields used 
      [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__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        Try 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
        ------------------------------