Convert from JSON to markdown/html table

Two ways I can think of to approach this:

  • Use a JavaScript column to parse the JSON and output the HTML table. The dates would be a bit fiddly, but other than that it should be pretty straight forward. (ChatGPT would be able to help you).
  • Use a series of Query JSON columns inside a Helper Table to pull the individual values, and then build the HTML with a Template and Joined List. Again, the dates would be a bit fiddly.

Now that I’ve typed that out, I think I’d favour the first option :wink:

2 Likes