Forum Discussion

JENNIFERPASCHAL's avatar
JENNIFERPASCHAL
Qrew Trainee
5 years ago

Notification Parent Rec Link

Hello -

I have an email that goes out if a record is added to a table. A notification then goes out alerting the user of this new record and displaying some of the fields in the content. This record is a child record, and the user will never need to go to this individual record...I need a link direct the user to the related record in the parent table. The only option in the Markers link to the child record or the application.

Is there a way to insert a link to the related record in a table-to-table relationship?

------------------------------
Thanks in advance,
Jennifer Paschal
------------------------------
NotificationsEmail
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    You can make your own hyperlink field using a formula Rich Text field type.

    var text URL = URLRoot() & "db/" & [_DBID of the parent table] & "?a=dr&rid=" & [Related Parent];
    var text Words = "Click here to go to the Parent Record";

    "<a href=" & $URL & ">" & $Words & "</a>"

    If you write the hyperlinks in this format,  the part in bold is always the same.





    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • JENNIFERPASCHAL's avatar
      JENNIFERPASCHAL
      Qrew Trainee
      5 years ago
      This worked perfectly thank you!

      ------------------------------
      Thanks in advance,
      Jennifer Paschal
      ------------------------------