Placeholders which contain html code in body resolve to literal text

23 views
Skip to first unread message

Sam Buccieri-Gillett

unread,
Jul 9, 2015, 9:11:53 AM7/9/15
to forme...@googlegroups.com
Hey guys,

First off - thanks for FormEmailer Henrique, it really is an incredibly useful piece of kit. I use it to send Google Forms input to a SpiceWorks-based helpdesk service. I'm using the formulas advanced function of FormEmailer, then using those as placeholders in the email. My formula columns/cells contain code which resolves to html-formatted text, which is intentional, however these get encoded once processed, so, for example, instead of an email output of
<h1>This field</h1>
<p>That field</p>
<p><em>The other field</em></p>

which would then be understood as html formatting, I just get the above, but literally as text.

So basically I can use html formatting in the body (with html enabled) but when I've got html code within placeholders, it gets output as literal text rather than code which is then interpreted.

I noticed the following from https://sites.google.com/site/formemailer/formatting:

The script also escapes any html entered by user (if you're using html body). To unable the user to "inject" formatting into your email by sending for example:
"I know html and can bold my texts <b>without your approval</b>!"
Now, you can disable this feature by providing the sHtml format. This should be used almost exclusive for columns with formulas written by you (along with the Formulas Location advanced parameter) but you may also want to let your users do this kind of dangerous thing, it's up to you.

How do I achieve this?

Thanks in advance to anyone who can shed some light on this!

Cheers!
Reply all
Reply to author
Forward
0 new messages