Is there any way to render custom HTML (for a Text widget, which seems to be the only theoretical way ?) from an SQL query result?
My thinking was that I could possibly set the Text from a JS function which in turn calls the SQL query, formats the result to HTML and then returns the HTML for the Text widget…
But first, I don’t understand how the SQL query actually async returns the data when called from JS and then I don’t see how the resulting HTML could be then set for the Text widget …?
@arminus Hey, instead of a text widget, have you tried rendering the HTML into the Iframe widget, using the srcDoc property?
Hey @dancia IFrame requires a URL which I don’t have for this usecase…?
The question is really, what can I do if the provided widgets aren’t sufficient. Of course I can build my own API/endpoint completely outside Appsmith, return some custom HTML and then put it into the IFrame.
I was just wondering if that’d be possible with just some JS inside Appsmith and only relying on an Appsmith query.
@arminus Sorry if I’m not understanding your question correctly, but the srcDoc property takes HTML. You don’t have to use the URL property.
Ok, I saw this and stopped. Will try again later
Cool, this works, thanks!