Load value form state variables pulled from data source

[benaunt]

Hi,

We are building an app that will store HTML code against various email templates within SQL.

In the Budibase app i want to display a preview of the HTML email as the user enters values into a form. So the HTML email will have mappings to variables attached to each field on the form.

This works if i paste the HTML code into a mark down viewer for one template.

As there are several different templates i actually want to store their code in SQL and dynamically display the preview based on which template has been selected on the form. I am still using a markdown viewer mapped to the code in my SQL data source to test this.

When I do this, all my variable declarations in the HTML code no longer display their values but instead display the variable declaration instead eg: {{ state.variablename }}.

Is there any way around this?

Thanks