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 all the orderItems - and I lookup a json objects like { “name”:“gear”, “numbers”: 3 } 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 It seems like when I go down the template column road then json data columns cannot be used to create the final json. I have tried different ways which can be seen in this demo app: [image] Tester (FinalJsonNotWorking1, FinalJsonNotWorking2 - yeah, they are not working) Is there a way to get the json created without using template column - and just using JSON columns. Final json { “company”: “MyCompany”, “order”: 1010, “orderItems”:[ { “name”:“gear”, “numbers”: 3 }, { “name”:“wheel”, “numbers”: 2 } ] } FinalJsonNotWorking2 [image] [image]

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 arrays using the Trebuchet method Part 2 is a deep dive on how you can Trebuchet more than a single value by creating arrays of JSON exploding_head. Check out how to build an inventory ordering app using the JSON Trebuchet Method! :popcorn:Enjoy! [Glide: Build an Inventory Ordering App Using the JSON Trebuchet Method]

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	8063	April 12, 2023
Advanced JSON Array Object Column \| Query Properties as JSON Array Feature Requests	6	194	March 7, 2025
Nesting JSON templates being treated as strings Ask for Help	3	73	January 17, 2025
Convert Data from Glidetable into JSON Type Ask for Help	7	1111	August 30, 2023
Help to understand the Different outputs from JSON Template column vs. normal template column Ask for Help	7	134	February 18, 2025

Arrays in json - how to create them

Related topics