Skip to main content
Question

Formula URL to Parent

  • December 10, 2019
  • 0 replies
  • 49 views
LeeGilmore
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
    JimHarrison
    Forum|alt.badge.img+18
    • JimHarrison
    • Registered
    • December 10, 2019
    Try this:
    URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [<email address field PK>]

    ------------------------------
    Jim Harrison
    ------------------------------
      Terms & ConditionsAccessibility statement