Forum Discussion

ClariceDennison's avatar
ClariceDennison
Qrew Trainee
4 years ago

URL Formula Field for Email Button

Hi!

In the formula field, is there a way to include an image in the email that is generated?

Initially, I was using the notification function to send out an email. However, because it was an external source, the image would not appear in the email unless the recipient right clicked where the image was.

So instead of using the notifcation, I had hoped to use the formula field instead.

Below was my HTML for the notification: (Not sure how to replicate in the formula field)

Thanks!


<!doctype html>
<html>
<head>
<meta charset="utf-8">
<!-- utf-8 works for most cases -->
<meta name="viewport" content="width=device-width, initial-scale=1.0">

<meta http-equiv="X-UA-Compatible" content="IE=edge">

<title>EmailTemplate</title>

<style type="text/css">
/* What it does: Remove spaces around the email design added by some email clients. */
/* Beware: It can remove the padding / margin and add a background color to the compose a reply window. */
html, body {
margin: 0 !important;
padding: 0 !important;
height: 100% !important;
width: 100% !important;
}
/* What it does: Stops email clients resizing small text. */
* {
-ms-text-size-adjust: 100%;
-webkit-text-size-adjust: 100%;
}
/* What it does: Forces Outlook.com to display emails full width. */
.ExternalClass {
width: 100%;
}
/* What is does: Centers email on Android 4.4 */
div[style*="margin: 16px 0"] {
margin: 0 !important;
}
/* What it does: Stops Outlook from adding extra spacing to tables. */
table, td {
mso-table-lspace: 0pt !important;
mso-table-rspace: 0pt !important;
}
/* What it does: Fixes webkit padding issue. Fix for Yahoo mail table alignment bug. Applies table-layout to the first 2 tables then removes for anything nested deeper. */
table {
border-spacing: 0 !important;
border-collapse: collapse !important;
table-layout: fixed !important;
margin: 0 auto !important;
}
table table table {
table-layout: auto;
}
/* What it does: Uses a better rendering method when resizing images in IE. */
img {
-ms-interpolation-mode: bicubic;
}
/* What it does: Overrides styles added when Yahoo's auto-senses a link. */
.yshortcuts a {
border-bottom: none !important;
}
/* What it does: Another work-around for iOS meddling in triggered links. */
a[x-apple-data-detectors] {
color: inherit !important;
}
</style>

<!-- Progressive Enhancements -->
<style type="text/css">
/* What it does: Hover styles for buttons */
.button-td, .button-a {
transition: all 100ms ease-in;
}
.button-td:hover, .button-a:hover {
background: #555555 !important;
border-color: #555555 !important;
}
</style>
</head>
<body width="100%" height="100%" bgcolor="#e0e0e0" style="margin: 0;" yahoo="yahoo">
<table cellpadding="0" cellspacing="0" border="0" height="100%" width="100%" bgcolor="#e0e0e0" style="border-collapse:collapse;">
<tr>
<td><center style="width: 100%;">

<!-- Visually Hidden Preheader Text : BEGIN -->
<div style="display:none;font-size:1px;line-height:1px;max-height:0px;max-width:0px;opacity:0;overflow:hidden;mso-hide:all;font-family: sans-serif;"> (Optional) This text will appear in the inbox preview, but not the email body. </div>
<!-- Visually Hidden Preheader Text : END -->

<div style="max-width: 600px;">
<!--[if (gte mso 9)|(IE)]>
<table cellspacing="0" cellpadding="0" border="0" width="600" align="center">
<tr>
<td>
<![endif]-->

<!-- Email Header : BEGIN -->
<table cellspacing="0" cellpadding="0" border="0" align="center" width="100%" style="max-width: 600px;">
<tr> </tr>
</table>
<!-- Email Header : END -->

<!-- Email Body : BEGIN -->
<table cellspacing="0" cellpadding="0" border="0" align="center" bgcolor="#ffffff" width="100%" style="max-width: 600px;">

<!-- Hero Image, Flush : BEGIN -->
<tr>
<td class="full-width-image" align="center" ><img src="file:///M|/ACM-ET/Tech_Team_Files/Icons/PNG/RCE ADKAR.png" width="222" alt="alt_text" border="0" style="width: 100%; max-width: 229px; height: auto;"></td>

</tr>
<!-- Hero Image, Flush : END -->

<!-- 1 Column Text : BEGIN -->
<tr>
<td><table cellspacing="0" cellpadding="0" border="0" width="100%">
<tr>
<td style="padding: 40px; font-family: sans-serif; font-size: 15px; mso-height-rule: exactly; line-height: 20px; color: #555555;"> Greetings! <br> <br> Enclosed is information about an upcoming change.

<br> <br> Who: [Impacted Area]
<br> <br> What: [Project Title]
<br> <br> When: [Go Live Date]
<br> <br> Why: [Description]
<br> <br> Contact Person: [Project Owners]
<br> <br>

<!-- Button : Begin -->

<table cellspacing="0" cellpadding="0" border="0" align="center" style="margin: auto;">
<tr>
<td style="border-radius: 3px; background: #222222; text-align: center;" class="button-td"><a href="https://spectrum.quickbase.com/db/bqradeyyx" style="background: #222222; border: 15px solid #222222; padding: 0 10px;color: #ffffff; font-family: sans-serif; font-size: 13px; line-height: 1.1; text-align: center; text-decoration: none; display: block; border-radius: 3px; font-weight: bold;" class="button-a">
<!--[if mso]>&nbsp;&nbsp;&nbsp;&nbsp;<![endif]-->Quickbase<!--[if mso]>&nbsp;&nbsp;&nbsp;&nbsp;<![endif]-->
</a></td>
</tr>
</table>

<!-- Button : END -->
<br>
A Small t-shirt Size Project Communication Plan Includes:
<br> <br>
<ol>
<li>Communication email to team.</li>
<li>Discussion during a Pod Huddle. Team members are encourage to ask questions and reach out for assistance.</li>
</ol>
<br>
</td>
</tr>
</table></td>
</tr>
<!-- 1 Column Text : BEGIN -->

<!-- Two Even Columns : BEGIN -->
<tr>
<td bgcolor="#ffffff" align="center" height="100%" valign="top" width="100%"><!--[if mso]>
<table cellspacing="0" cellpadding="0" border="0" align="center" width="560">
<tr>
<td align="center" valign="top" width="560">
<![endif]-->

<table border="0" cellpadding="0" cellspacing="0" align="center" width="100%" style="max-width:560px;">
<tr> </tr>
</table>

<!--[if mso]>
</td>
</tr>
</table>
<![endif]--></td>
</tr>
<!-- Two Even Columns : END -->

</table>
<!-- Email Body : END -->

<!-- Email Footer : BEGIN -->
<table cellspacing="0" cellpadding="0" border="0" align="center" width="100%" style="max-width: 680px;">
<tr>
<td style="padding: 40px 10px;width: 100%;font-size: 12px; font-family: sans-serif; mso-height-rule: exactly; line-height:18px; text-align: center; color: #888888;">
<br>
<br>
Revenue Cycle Education
<br>
<span class="mobile-link--footer">Change Management</span> <br>
<br>
</td>
</tr>
</table>
<!-- Email Footer : END -->

<!--[if (gte mso 9)|(IE)]>
</td>
</tr>
</table>
<![endif]-->
</div>
</center></td>
</tr>
</table>
</body>
</html>

------------------------------
Clarice Dennison
------------------------------
  • If you have a Rich Text formula field like this  and use the field in the Notifiation include syntax like this, it will show an image

    "<img src=" & URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e282/v0' width='75' >"

    In this case my file attachment field is fid 282.  You need to checkbox the field properties to be able have the attachment viewable when not logged in, otherwise the receiver's email system will not be able to pull the image.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • ClariceDennison's avatar
      ClariceDennison
      Qrew Trainee
      Thanks Mark! I'll give this a try. Circling back to the notification/another question came to mind, is there way for these email notifications to not be viewed as an "external email"?



      ------------------------------
      Clarice Dennison
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        If you use The third-party add on from Juiced called Courier then you can have the notifications come from your own email server. Then they would not be seen as external.


        https://www.juicedtech.com/courier

        ------------------------------
        Mark Shnier (YQC)
        mark.shnier@gmail.com
        ------------------------------