API Link Redirect Not Working

OK great. Yes, as you have discovered a regular URL field looks ugly as heck in an email and not very inviting to click.

this button information comes out of examples from Kirk Trachy and his magic buttons app. I will paste in my cheat notes directly, and you can figure it out from there. Note that the field must be formula Rich Text, and not formula URL.

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