Translated HTML fields show HTML code in email notifications

[rosa8]

For some reason when I include a field that is a Translated HTML field into an email notification, the HTML code prints and it looks like a mess. How do I get the data from the field to format properly? Regular HTML fields work fine.

I first noticed this when working on our kb_submission form. I'm trying to get the text to be included in the approval email notification. I'm also trying to include that same text in a notification to the Service Desk for Knowledge Articles are updated.

Thanks,
Rosa

[rosa8]

<div><p>&amp;&amp;&amp;&amp;&amp;&amp;&amp;&amp;&amp;&amp;&amp;&amp;&amp;&amp;&amp;&amp;&amp;&amp;&amp;</p><p>For all GERS incidents that can't be resolve by other knowledge, CHECK KNOWLEDGE - SEARCH ON GERS,<br />transfer to AMER GERS.<br /><br />There is an automated process that occurs when using this SVD that sends an alert to two pagers and a cell phone at Baker. Thisis the process defined by GERS support at Baker. Amer Baker will bypass this system. <br /><br />(As of Jan, 10, 2006 there are 5 knowledge pieces to read before transferring.) <br /><br />Cause Item: GERS<br />Cause: Varies<br /><br />Created by: Todd Grube<br />Creation: Nov7, 2007<br />Edited by: Eric Hildebrand </p> </div><div> </div><div> </div><div> </div><div><a href="https://kohlersandbox.service-now.com/nav_to.do?uri=kb_submission.do%3Fsys_id=313e007529816c00cd765627de9578a6%26sysparm_scriptlet%3dcurrent.u_knowledge_article_number.number%26sysparm_view%3dkb_view%26sysparm_stack=kb_submission_list.do%3Fsysparm_query=active=true">LINK</a></div><div> </div><div>Click here for instructions on how to filter email from Kohler.Service-Now.com.  <a href=https://kohler.service-now.com/kb_view.do?sysparm_article=KB16359>Knowledge</a></div><div> </div><div style='display:inline'>Ref:MSG074876</div>

[cwhaley]

I'm not sure that it came over correctly because It looks like the code tagger may have converted the < to <, > to >, etc.

Can you post a screenshot of this field from that same record? You can attach using the "File Attachments" link under the comments textbox.

[rosa8]

I attached the body of the email that is probably a better example. . Maybe it will be easier if I explain what I'm trying to do.
We have a kb_submission for a changed knowledge. If it is a major change, an email notification is sent to the Service Desk to make them aware of that change. The notification event is triggered from the kb_submission table which includes a reference field with the knowledge article number. In the email I'm using the following field.

${u_knowledge_article_number.text}

I appreciate your help.

[rosa8]

I attached another example screen shot for better clarification. I included the text field from the KB Submission form which is an HTML field and the text field from the Knowledge form which is a Translated HTML field. You can definately see the difference. The KB Submission field looks great and the Knowledge field is a run on with the html code displayed.

Thanks again,
Rosa

[Masha]

When you applied the mail_script suggested by cwhaley, did the resulting text have any HTML or < type of tags at all or was it just plain text?