Forum Discussion

LeeGilmore's avatar
LeeGilmore
Quickbase Alumni
6 years ago

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 the user to the Parent but instead to the drill down. I need to recreate the ability help the user get to the parent record in a Summary Report. The primary key of the parent is actually an e-mail address. I'm less than stellar at Formula URLs and I see where mostly it references Record ID. Does having a different key field cause issues for what I want to accomplish?

------------------------------
Lee Gilmore
------------------------------
formulas
Relationships
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    The generic format to access a record by the key field would be

    URLRoot() & "db/" & [_DBID_PARENT_RECORD] & "?a=dr&key=" & ToText([email])


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
  • JimHarrison's avatar
    JimHarrison
    Qrew Champion
    6 years ago
    Try this:
    URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [<email address field PK>]

    ------------------------------
    Jim Harrison
    ------------------------------
    • LeeGilmore's avatar
      LeeGilmore
      Quickbase Alumni
      6 years ago
      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
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        6 years ago
        If 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
        ------------------------------