Forum Discussion

SystemUser2's avatar
SystemUser2
Qrew Member
2 years ago

Turn notification hyperlink into a button

Hello! I am creating a notification and am wondering if I can change the hyperlink listed in the notification into a button. Is this possible via a rich-text formula? Please let me know!



------------------------------
System User
------------------------------
  • Yes exactly, you need to have a Rich Text field type to have the appearance of the button survive e-mail.

    Here are my cheat notes.  Two examples.

    Emailable button (Magic Buttons Kirk Trachey) w/ obscure record id (rid) Yes  
    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 URL = [Log In URL];
    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>"



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • SystemUser2's avatar
      SystemUser2
      Qrew Member

      Thanks Mark!

      So both will achieve the same result?



      ------------------------------
      System User
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend

        Well, yes, the URL is the URL. So it just depends what the URL fit into it is, but it's just a question of whether the URL appears as an ugly, long, character, string, or a button.

        Well, yes, the URL is the URL. So it just but it's just a question of whether the URL appears as an ugly, long, character, string, or a button.

        You will find in your testing that the appearance of the button on a form will be slightly different than the appearance of the button in the email. It'll still be pretty, but you might have to iterate back-and-forth if you're trying to get a really beautiful button and get the exact look you want. 



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------