Create HTML bulleted list from array save in Airtable

How To
, ,
1

Hi -

I’m struggling to create a list from data stored in an Airtable field.

I have a scenario that saves key points from multiple email newsletters in a field in Airtable. It uses ChatGPT to write key points for email newsletters, which are contained in an array that gets saved to a field in Airtable as rich text.

I’ve created a second scenario (blueprint attached) that retrieves the information from Airtable so that I can summarize it in an email. For this second scenario, I can get the rich text out of Airtable (attached).

email
email1920×933 179 KB

How do I display the information as a bullet-pointed list in my email?

Any suggestions are much appreciated.

I’m sure someone has dealt with this but I haven’t found anything on the forum.

Thanks!

blueprint-3.json (20.4 KB)

2

You need to use a Text Aggregator to combine all the items in the Search Airtable with a HTML list item tags:

<li>Result content goes here</li>

Alternatively, ask OpenAI GPT to return the result in HTML.

For more information, see HTML formatting and search the forum for HTML email.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

3

Thank you so much.

Just to make sure I understand, are you saying that I should use a Text Aggregator to save the key points in Airtable with the

  • tags? The key points will then be formatted for an HTML list when I extract the data for my email. I attached the blueprint for that scenario in case it clarifies this question.

    I’ll spend some time in the academy as well.

    Thanks!!
    blueprint-4.json (32.7 KB)

    4

    Look, you’ve created one list item bullet yourself in your post because the forum software accepts (a subset of) HTML.

    5

    I get that. I was asking if I need to save the tags in the database field or add them at retrieval. I’ll figure it out. Thanks