Notification Parent Rec Link

Question

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

MarkShnierYou · Answer

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

Sign up

Login to the community