Forum Discussion

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! --------...

MarkShnier__You

Qrew Legend

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.

Title

Emailable button (Magic Buttons Kirk Trachey) w/ obscure record id (rid)

Flag as good for clients to see

Technique

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

Qrew Member

2 years ago

Thanks Mark!

So both will achieve the same result?

------------------------------
System User
------------------------------

MarkShnier__You
Qrew Legend
2 years ago
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
------------------------------
- MikeTamoush
  Qrew Commander
  2 years ago
  Mark,
  
  Do you know what each piece of this means? :font: normal 700 24px/1 \"Calibri\", sans-serif;
  
  Some seems obvious but some does not to me, like the 700 and the /1, plus which is the font, and what is the other one?
  
  When I put a button in email, my padding did not work but if i made my words like this: & "'>&nbsp&nbsp" & $ButtonWords & "&nbsp&nbsp</a>"
  
  that made it look much nicer. I'm curious to try your code though.
  
  ------------------------------
  Mike Tamoush
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    2 years ago
    Monkey see monkey do. I mostly just fake my way through those parameters. I don't really know what they all mean. Truthfully I'm not sure. Kirk Trachy knew either as he got his information from the gurus inside Quickbase.
    
    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------