I have a table with order items and a table with orders The order items table have the columns order, name and numbers I need to create a json like below. I find it hard to create the array using JSON columns - but maybe it isn’t actually possible? I can create a relation (match multiple) to get…

You can try pointing the orderItems variable straight at the lookup, instead of doing this. [image] Krivo: The lookup’ed column (the above json object) is then transformed by a joined list Then a template column to add square brackets around the joined list

Arrays in json - how to create them

Ask for Help

Sekayi_Liburd June 8, 2024, 9:49pm 2

I haven’t tried it myself but did you do it the same way as in this video?

1 Like

Topic		Replies	Views
Creating JSON from columns with multiple values Ask for Help	16	7400	April 13, 2023
Advanced JSON Array Object Column \| Query Properties as JSON Array Feature Requests	6	78	March 7, 2025
Nesting JSON templates being treated as strings Ask for Help	4	30	January 24, 2025
Convert Data from Glidetable into JSON Type Ask for Help	7	1046	August 30, 2023
Help to understand the Different outputs from JSON Template column vs. normal template column Ask for Help	8	38	February 25, 2025

Arrays in json - how to create them

Related topics