Forum Discussion

KellyLyons1's avatar
KellyLyons1
Qrew Cadet
6 months ago

Rich text lookup field not displaying correct when emailing a report

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...
formulas
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 months ago

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

 

KellyLyons1's avatar
KellyLyons1
Qrew Cadet
6 months ago

Hi Mark, the field in my report is a rich text lookup field.  I am using this field for the sorting/grouping for this specific report.   It is not a button

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 months ago

    In my experience if you use a Rich Text field on an old style report, you can use it as a Group By as sort of a header to a group of records. 

    But that functionality is not supported in New Style reports. Is that the issue? Legacy report behavior vs New Style behavior for Group By?