Email Template – Generating Subject with an Field containing Ampersand

Hi Guys,
Have you encountered the issue, where you have an Ampersand in the field value, causing the template to be generated with the escape character “&”.

And to complicate it even further, the field is being used on the Subject part of the email, which makes it even more complicated.

Replacing the ampersand with the escape character in a field formula didn’t help.

Replacing it in the template, as NetSuite suggests, has no affects whatsoever.

Using the un_esc tag is not supported in the output_format.

Rookie Asked on February 23, 2020 in SuiteScript.
Add Comment
1 Answer(s)

Can you share where and how you are attempting to escape that character?
Also, are you using scriptable templates within SuiteScript 2.0? What’s the exact context of execution?

Beginner Answered on March 16, 2020.

Hi,
It’s indeed a scriptable email template, being generated by an SS1.0 Workflow action.

For example, if one of the fields in the subject have a value such as “FP&A”, the email will be generated with an escaped character, meaning, the email will arrive as FP&A.

On Email buddy there is no such issue, because of the no_esc setting, which has no influence on the subject.
Also,  doing a replace in the subject formula (replacing & with &), works only till the next edit of the template (Since the template engine replaces the & back to &).

 

There are workarounds, but wa just wondering if someone was able to solve it without any workaournds.

 

on April 6, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor