Generate plain HTML using all records from table

Question

Hi all,

I'm trying to generate a block of plain HTML that uses certain fields from all records in a table, and places these into a standard format. The idea is to generate the HTML which can copied and pasted to a third-party web publishing platform.

The HTML is fairly simple - just bulleted lists and a few headings. Here's the general HTML format I want to follow.

&lt;h4&gt;Static heading text&lt;/h4&gt;
&lt;ul&gt;
&nbsp; &lt;li&gt;
&nbsp; &nbsp; &lt;strong&gt;[Field 1 from first record - only if it has a certain field value]&lt;/strong&gt;&lt;br&gt;
&nbsp; &nbsp; [Field 2 from first record - only if it has a certain field value]
&nbsp; &lt;/li&gt;

&nbsp; ...(generate using all records from a table)

&nbsp; &lt;li&gt;
&nbsp; &nbsp; &lt;strong&gt;[Field 1 from last record of table]&lt;/strong&gt;&lt;br&gt;
&nbsp; &nbsp; [Field 2 from last record - only if it has a certain field value]
&nbsp; &lt;/li&gt;
&lt;/ul&gt;

I've done something similar in Google Sheet where certain cells are static while others use a FILTER formula to populate accordingly. I then highlight all the cells to copy and paste to a publishing platform. I also used various formulas so that the static cells are populated if a relevant cell contains text so that there's no empty HTML tags. Hoping something similar can be accomplished in Quickbase.
------------------------------Frontman------------------------------

marcelobenavide · Answer

You need use a code page with JavaScript and html.Marcelo Benavides&nbsp;

frontman · Answer

Do you have an example you can share? I'm looking to generate the actual HTML code block itself instead the HTML page - which is what most other discussion threads seem to be about.

------------------------------
Frontman
------------------------------

Forum Discussion

Generate plain HTML using all records from table