Custom Message Notification, href to Edit Record

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • In Progress
For a custom message notification, I'm trying to use a href to hyperlink a word to open the related record in edit mode. 

The Custom Message html: 
<p>Once the sample is received, click <a href="[Edit Record Button]">here </a>and update the  information found under the <b> IH Sample Processing</b> tab.</p>

The Edit Record Button code:
URLRoot() & "DB/" & Dbid() & "?a=er&rid=" & [Record ID#]

E-mail Notification: 
Once the sample is received, click bpgmmp5dd?a=er&rid=0">here and update the information found under the IH Sample Processing tab.

What am I missing?

(I also know that I could just use the marker %recLink%, but I'm trying to clean up the e-mail a bit.)
Photo of Brianna Yankus

Brianna Yankus

  • 70 Points

Posted 1 month ago

  • 0
  • 1
Photo of Everett Patterson

Everett Patterson

  • 1,058 Points 1k badge 2x thumb
Create a new form called Notification Emails and only put the Edit Record button on that form

On the custom message, use the %recLink% and on the dropdown box " Form to use when including a copy"  select the new form, the link will now show up by itself on the email
Kirk Trachy, Quick Base Employee / full time Quick Base Evangelist has an app in the exchange called Magic Buttons.  I suggest downloading it and dating it in the title in your local copy as he keep reloading it with new tricks, but his app always has the same name.  So hen you download the new one every few months, delete your old one.

He has a tip there on how to make buttons that look good in emails

// Begin button style
var text bgcolor = "#4285F4";
var text txtcolor = "white";
var text style = "style=\"text-decoration: none; width: 120px; text-align: center; background:" & $bgcolor & "; border-radius: 5px; padding: 8px 20px; color: " & $txtcolor & "; display: inline-block; font: normal 700 24px/1 \"Calibri\", sans-serif; text-shadow: none;";
// End button style

"<a " & $style & " href='https://www.w3schools.com/colors/colors_brands.asp' title='Brand Colors'>Google Blue</a>"

// Great resource to create our own style of button. https://dabuttonfactory.com/
// Other brand colors: https://www.w3schools.com/colors/colors_brands.asp
// NOTE:  These buttons survive emailing.  Formula URL buttons or buttons created with QuickBase's existing classes do not render when sent in an email.  These do!