Forum Discussion

KellyLyons1's avatar
KellyLyons1
Qrew Cadet
2 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 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?
  • How does your field display in the record as opposed to the email?

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

     

     

  • 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.  

     

     

    • DonLarson's avatar
      DonLarson
      Qrew Elite

      My apologies for that one.  Let me play with a test record here.

  • 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

      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

        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?