Making a field and marker link in email notificaton

Question

Hello,I am trying to make email notification that reads.A CR has been issued for PID [Request ID/PID] mapped to QB Record [Record ID#]. However with the first inserted field [Request ID/PID] , I'd like to make that a link to the record (%recLink%) aka a marker link to the related record. Normally to add a link to a QB notification I would use NAME OF LINK. But in this case it will not work. Id like the LINK to be the %recLink% and the name of the link the be the field (which would change depending on which record has been modified).Is this possible?Thanks, Noel------------------------------NOEL HODGES------------------------------

MarkShnierYou · Answer

You will need to make you own hyperlink as a Rich Text formula field

var text Words = "Some words or formula goes here";

var text URL = URLRoot() & "db/" & dbid() & "?a=dr&rid=" & [Record ID#];

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

Sign up

Login to the community