Forum Discussion

NOELHODGES's avatar
NOELHODGES
Qrew Cadet
4 years ago

Making a field and marker link in email notificaton

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 <a href=" LINK">NAME OF LINK</a>. 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
------------------------------
NotificationsEmail
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    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
    ------------------------------