Discussions

Expand all | Collapse all

Custom Message Notification, href to Edit Record

  • 1.  Custom Message Notification, href to Edit Record

    Posted 07-10-2019 13:55
    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.)


  • 2.  RE: Custom Message Notification, href to Edit Record

    Posted 07-10-2019 14:53
    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


  • 3.  RE: Custom Message Notification, href to Edit Record

    Posted 07-10-2019 19:18
    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!