Skip to main content
Question

Rich text lookup field not displaying correct when emailing a report

  • October 9, 2024
  • 0 replies
  • 309 views

Forum|alt.badge.img+7

When I email a report from QB, I have a rich text lookup field that is not displaying correctly, it is showing the  actual code: 

<span style='font-family: Gibson-Regular; font-size: 13px;'>Aviation and Occupational Medicine</span><br><span style='font-family: Gibson-Regular; font-size: 10px;'>6900 East 47th Avenue Drive<br>STE 100<br>Denver, CO 80216</span> (8 AP Invoice)

Any ideas why or how to correct this issue?

Forum|alt.badge.img+15
  • Quickbase Alumni
  • October 9, 2024

Is the Message format set to HTML?

 


MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • October 9, 2024

Are you sure the field type is Rich Text?

This is one version I use for emailable  buttons

 

var text URL = url goes here;


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

 


Forum|alt.badge.img+7
  • Author
  • Quickbase Alumni
  • October 9, 2024

This isn't a subscription email.  I am on my report, and then just click on the 3 dots, and am selecting email.  In that screen (see attached) does not have that option.  

 

 


Forum|alt.badge.img+15
  • Quickbase Alumni
  • October 9, 2024

I created a new Formula Rich Text and put an image in it.   Then I used the In Record Email option.

 

 


Forum|alt.badge.img+15
  • Quickbase Alumni
  • October 9, 2024

How does your field display in the record as opposed to the email?