Forum Discussion

HannahEngelson's avatar
HannahEngelson
Qrew Trainee
17 hours ago
Solved

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 s...
  • MarkShnier__You's avatar
    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 words

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