Righteo, so here's an interesting challenge..
I'm trying to find a clean way to display a dynamic list of line items from a database look up in an HTML block within a Laserfiche form (without using a table or repeating item group).
What we've got so far is the first form submission triggering a workflow, which does a database query, returning data which is merged into a Word document template. Using the advanced "Emit Email Token" option, the output of this Word document can be used in the body of an email as HTML (and looks great) but I'm having trouble finding a way to get the HTML content of this token back into Laserfiche Forms.
When I use the "Update Business Process Variable" and add the email token (which is available to be selected) to a Rich Text Field (for the second, or subsequent tasks/forms), it just displays the file path to the emitted email token rather than the contents of the token.
Does anyone have some creative ideas on how to convert that special email token into HTML so that we can put into a Rich Text Field (and therefore use in an HTML block via dataset variable)?