Discussions

Expand all | Collapse all

How to go to grand parent record

  • 1.  How to go to grand parent record

    Posted 12-13-2019 00:49
    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
    ------------------------------


  • 2.  RE: How to go to grand parent record

    Posted 12-13-2019 13:08
    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
    ------------------------------



  • 3.  RE: How to go to grand parent record

    Posted 16 days 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
    ------------------------------



  • 4.  RE: How to go to grand parent record

    Posted 16 days 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
    ------------------------------



  • 5.  RE: How to go to grand parent record

    Posted 16 days ago
    That worked perfectly. Thanks!

    ------------------------------
    Amanda Torrisi
    ------------------------------