Link to Record in Outlook Pipeline
Hey Qrew,
I have an app tracking employee safety reports. I have Pipeline emails that send out when a new report is submitted, when it's assigned to someone for follow up, and when that person has submitted the response.
I need it to be a Pipeline email instead of a native notification because I need it to send as an email thread to everyone instead of to each person individually. I'm trying to add a link that says "Click here to open the record" in the email so the person it's been assigned to can open the form and modify the fields their role has access to.
Can someone help me create that jinja code? I've tried to find it somewhere in the ether and can't find anything that's specific to what I need. Thank you!!
Here are a couple of examples of formula Rich Text field to build in native Quickbase that you can inclue in the body of the email.
var text DisplayRecordWithObsureRID = URLRoot() & "db/" & Dbid()
& "?a=dr&r=" & QB32Encode([Record ID#]);
var text URL = $DisplayRecordWithObsureRID;
var text ButtonWords = "Click here to Update ETD and ETA dates";// Begin button style
var text bgcolor = "#34A853";
var text txtcolor = "white";
var text style = "style=\"text-decoration: none; width: 250px; text-align: center; background:" & $bgcolor & "; border-radius: 5px; padding: 8px 10px; color: " & $txtcolor & "; display: inline-block; font: normal 700 24px/1 \"Calibri\", sans-serif; text-shadow: none;";
// End button style"<a " & $style & " href=" & $URL & ">" & $ButtonWords & "</a>"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
button with a larger font and floating width to accommodate the wordsvar text DisplayRecordWithObsureRID = URLRoot() & "db/" & Dbid()
& "?a=dr&r=" & QB32Encode([Record ID#]);
var text URL = $DisplayRecordWithObsureRID;var text ButtonWords = "Log In";
// Begin button style
var text bgcolor = "#34A853"; // green
var text txtcolor = "white";
var text style = "style=\"text-decoration: none; text-align: center; background:" & $bgcolor & "; border-radius: 5px; padding: 8px 10px; color: " & $txtcolor & "; display: inline-block; font-size: 150%; font: normal 700 24px/1 \"Calibri\", sans-serif; text-shadow: none;";
// End button style"<a " & $style & " href=" & $URL & ">" & $ButtonWords & "</a>"
