Solved: HTML start expression fails when exact same expres... - Page 2

TyAlevizos · 03-23-2020 11:53 AM

Steps to reproduce, FYI for anyone that runs into this:

create an html attachment template on a workflow. Your syntax needs to escape less-than and greater-than signs, e.g. it looks like this:

&lt;&lt;Start: SELECT(table[UniqueID],[STATE] = [_THISROW].[STATE])&gt;&gt;
&lt;&lt;[SomeField]&gt;&gt;: &lt;&lt;[Another Field]&gt;&gt;
<br/>
&lt;&lt;End&gt;&gt;

This fails, appsheet says it cannot find the function “START: SELECT” - if you use actual < and > you get a different error.

This exact same syntax - except for not escaping the < and > - in a google doc works fine:

<<Start: SELECT(table[UniqueID],[STATE] = [_THISROW].[STATE])>>
<<[SomeField]>>: <<[Another Field]>>
<<End>>

Let me know if you have ever seen this, or, put more simply: anyone have a working example of a start expression with an arbitrary select statement, and using the HTML output type?

Phil

The error is occurring because in the failing HTML file, the Start/End expression is not inside an HTML <p> or <heading> element. Instead, the Start/End expression is at the bottom of the HTML <body> element. This is causing a parsing problem that is not easy for me to fix. You can circumvent the problem by enclosing that Start/End expression in an HTML <p> element.

The HTML at the bottom of the file currently looks like this:

<p>&lt;&lt;End&gt;&gt;</p>
    <br />
    <br />&lt;&lt;Start: Select(Parent[Key],True)&gt;&gt;[Name]<br />&lt;&lt;End&gt;&gt;</body>
</html>

It needs to look like this:

<p>&lt;&lt;End&gt;&gt;</p>
    <br />
    <br /><p>&lt;&lt;Start: Select(Parent[Key],True)&gt;&gt;[Name]<br />&lt;&lt;End&gt;&gt;</p></body>
</html>

View solution in original post

HTML start expression fails when exact same expression works in google doc