Display data from either Query or Multiple Relations

[ThinhDinh]

Transpose Columns to an Inline List: The Miracle Method

I’m often asked how to take columns of data (say form responses) and display them in an inline list. Here’s one way to do it—the MIRACLE METHOD. [Glide: Transpose Data Columns into an Inline List with the MIRACLE METHOD]

This is the method you need. It’s an old thread, but would give you the right ideas to that. Basically create a new table, get the JSON over there, add as many rows as you need to store the JSON elements, and finally parse them using Query JSON columns.