Link to Record in Outlook Pipeline
- 16 hours ago
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>"