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

I haven’t tried it myself but did you do it the same way as in this video? [image] dizzyaccordion JSON Trebuchet Community Resources wave Hey fellow Gliders! Part two of my Trebuchet series is live! Last week, I posted a tutorial on a new way to create inline…

I would definitely have a look. Thx

@ThinhDinh Well your suggestion worked! Cool. So you just need to have an array of values (like from a multiple relation). Good to know [image] [image]

Yeah, that’s what they rolled out a while ago and it’s much easier than creating template columns :wink:

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?

Topic		Replies	Views
Creating JSON from columns with multiple values Ask for Help	15	7903	April 12, 2023
Advanced JSON Array Object Column \| Query Properties as JSON Array Feature Requests	6	143	March 7, 2025
Nesting JSON templates being treated as strings Ask for Help	3	47	January 17, 2025
Convert Data from Glidetable into JSON Type Ask for Help	7	1069	August 30, 2023
Help to understand the Different outputs from JSON Template column vs. normal template column Ask for Help	7	77	February 18, 2025

Arrays in json - how to create them

Related topics