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.
<h4>Static heading text</h4><ul> <li> <strong>[Field 1 from first record - only if it has a certain field value]</strong><br> [Field 2 from first record - only if it has a certain field value] </li> ...(generate using all records from a table) <li> <strong>[Field 1 from last record of table]</strong><br> [Field 2 from last record - only if it has a certain field value] </li></ul>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
------------------------------
