# JSON from multiple tables to one table **URL:** \ **Category:** Ask for Help\ **Created:** [June 26, 2025, 6:52am UTC](https://community.glideapps.com/t/json-from-multiple-tables-to-one-table/82747 "2025-06-26T06:52:34Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![SageCat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sagecat/32/85273_2.png) [@SageCat](https://community.glideapps.com/u/SageCat)\ **Post date:** [June 26, 2025, 6:52am UTC](https://community.glideapps.com/t/json-from-multiple-tables-to-one-table/82747/1 "2025-06-26T06:52:34Z")
Ok, I’m needing some help as I’m not sure how to approach this. Basically, I want to create a helper table that will be used to make a HTML file. The helper table will need data from three tables, namely Animals, Medical and Neonate. I’m thinking that based on the Animal\_ID from the Animals table (which the button is coming from so easy enough to get data from that table), it will then get all rows in both the medical and neonate tables relating to that animal\_ID but I’m not sure how to do that. I thought I could make a JSON column in the two tables and simply look that up from the helper table… which works but then I can’t extract the data from the JSON file as it is no longer a JSON file but a lookup… Maybe I’m thinking about this all wrong so please feel free to point me in the right direction. I went with a helper table as I figured I would need to have a column for every extraction of data from JSON file… but maybe that isn’t right. Maybe in the Animal table, the table which the button runs from, I should do this… I’m not sure. The end goal is a HTML file that displays three sets of data in relation to the animal - the general info in the animal table (easy), any rows of data relating to that animal in medical and same again for neonate. I’m no expert - I can’t code and I don’t know any languages, but I’m learning… But I just can’t get my head around this so would appreciate any help. ---
**Author:** ![Nicolas\_Joseph](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nicolas_joseph/32/76105_2.png) [@Nicolas\_Joseph](https://community.glideapps.com/u/Nicolas_Joseph)\ **Post date:** [June 26, 2025, 12:01pm UTC](https://community.glideapps.com/t/json-from-multiple-tables-to-one-table/82747/2 "2025-06-26T12:01:18Z")
Hi @SageCat! Many ideas here, so let’s start by clarifying some concepts and see where that leads 😉 > [@SageCat](#): > > three tables, namely Animals, Medical and Neonate First of all, that’s usually a good approach to create a table for each purpose, so well done! * * * > [@SageCat](#): > > I’m thinking that based on the Animal\_ID from the Animals table (which the button is coming from so easy enough to get data from that table), it will then get all rows in both the medical and neonate tables relating to that animal\_ID but I’m not sure how to do that. In Glide, you can easily bring data from another table based on a common value using a column called _Relation_. There’s also a _Query_ column for more advanced use cases, especially when you want to apply filters. You just have to add a new _Relation_ column in your **`Animals`** table and set it up to match rows from **`Medical`**. Then proceed in the same way for data in **`Neonate`** (one relation for each targeted table). Here’s the doc (with a step-by-step walkthrough): [Relations | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/relations) You can then use these relations to display data in _Layout_ and/or apply calculations, aggregations and so on in the _Data_ pane (for example, counting the number of rows with a _Rollup_ [[Rollup Column | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/rollup-column)], looking for a value [[Lookup | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/lookup-column)]…). * * * > [@SageCat](#): > > The end goal is a HTML file that displays three sets of data in relation to the animal So, do you want the user to be able to download an HTML template document? Or is it just about creating a screen in Glide to display these data coming from multiple tables as mentioned previously? Both are possible, and the answer will depend on your aim here (either by using computed columns such as _Template_, I imagine, or directly in the _Layout_ with _Collections_ components targeting the _Relation_ column). * * * > [@SageCat](#): > > I can’t extract the data from the JSON file as it is no longer a JSON file but a lookup Technicaly, a JSON file is just a formated string. Indeed, if you apply a _Lookup_, the result in Glide isn’t always a string but an _array_ (with a _pill_ design displayed). By using a _Single Value_ column or a _Template_ column, you can cast the array into a string like this: ![Array to text](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/1/c17e5381515b20d457f77ff8025c76369ad96295.png) After that, it’s quite simple to get information from the JSON using - for example - a _Query JSON_ column: ![Query JSON](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/d/3d7b06ba8cd35ef51cc887bf4814361ab1705505.png) * * * > [@SageCat](#): > > I’m no expert - I can’t code and I don’t know any languages, but I’m learning… We’re all in the same boat, constantly learning 😛 ---
**Author:** ![SageCat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sagecat/32/85273_2.png) [@SageCat](https://community.glideapps.com/u/SageCat)\ **Post date:** [June 27, 2025, 12:51am UTC](https://community.glideapps.com/t/json-from-multiple-tables-to-one-table/82747/3 "2025-06-27T00:51:29Z")
Morning Nicolas Thanks for your great email. I have already got relations set up in each of the three tables where necessary, so that I can show in the app all the medical or neonatal data in relation to the selected animal. I just wasn’t sure how to get that info to the helper table as a JSON (which I assume I need to have it has to get it to HTML). The end goal of the HTML is to use it with HTML2PDF so I can print the data. I’m trying to develop an app for rescues to be as workable as possible in the free version (because I know rescues are always scrambling for money) so that they can run in free for as long as possible but the inability to print is a big thing… so I was hoping I could use the data from Glide to make a HTML version of the screen in Glide so it can print… and that’s where I ran into trouble 😹 ITs getting the JSON file from each table to the helper table so I can then extract out to make the HTML file. I’m planning that the record is only in the helper table to generate the HTML and then it would be deleted - I hope this all makes sense to you. ---
**Author:** ![SageCat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sagecat/32/85273_2.png) [@SageCat](https://community.glideapps.com/u/SageCat)\ **Post date:** [June 27, 2025, 3:03am UTC](https://community.glideapps.com/t/json-from-multiple-tables-to-one-table/82747/4 "2025-06-27T03:03:20Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/0/d0ca50283bc12e3551d2c77319fd8cc47dfd0b24.png) Above is what I get. The rel to Animals works as I’m only getting a single match, but medical and neonate is multiple match and whilst the rel to them works, I then can’t work out how to get at that data so I can show it in HTML. Lookup doesn’t work as I no longer sees that column as an option to select, I assume because it is multiple matches (because relAnimals still shows but that is singular). Hope this makes sense. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [June 27, 2025, 5:49am UTC](https://community.glideapps.com/t/json-from-multiple-tables-to-one-table/82747/5 "2025-06-27T05:49:43Z")
Have you tried a Joined List? ---
**Author:** ![SageCat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sagecat/32/85273_2.png) [@SageCat](https://community.glideapps.com/u/SageCat)\ **Post date:** [June 27, 2025, 6:10am UTC](https://community.glideapps.com/t/json-from-multiple-tables-to-one-table/82747/6 "2025-06-27T06:10:31Z")
Ahhh… ok, so what I’ve done in the helper file is this which appear to be working… Thanks you! Now to work out getting the data from medical and neonate into a table, given the amount of data would be different for each animal… ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/optimized/3X/c/7/c700adc5a08d681015f9d4b75485f65ec5000c73_2_690x39.png) ---
**Author:** ![SageCat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sagecat/32/85273_2.png) [@SageCat](https://community.glideapps.com/u/SageCat)\ **Post date:** [June 27, 2025, 6:12am UTC](https://community.glideapps.com/t/json-from-multiple-tables-to-one-table/82747/7 "2025-06-27T06:12:58Z")
Actually, a thought… would I be better off having three helper tables, each which would temporarily contain the data for each animal - one for animal (one row), one for medical (X rows) and one for neonate (X rows)… Or is that just going around in circles? I just thought that way maybe it might be easier to show the tables which will have unknown number of rows of data. ---
**Author:** ![Nicolas\_Joseph](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nicolas_joseph/32/76105_2.png) [@Nicolas\_Joseph](https://community.glideapps.com/u/Nicolas_Joseph)\ **Post date:** [June 27, 2025, 7:48pm UTC](https://community.glideapps.com/t/json-from-multiple-tables-to-one-table/82747/8 "2025-06-27T19:48:21Z")
OK, it’s easier to understand now with your explanations 👍 Your objective is to have a HTML content in a column. And this HTML content have to be dynamic (the number of values is not always the same). As @Jeff_Hager mentioned, you could use `Joined List` to your advantage. But the trick is to use formated HTML content. So instead of getting `a, b, c`, you’ll get `
  • a
  • b
  • c
    • ` for a bullet point list (for example). Here how it works 👇 - In your **`Medial`** table, add a _Template_ column. Set it up like this: - In your main table, after you established _Relation_ columns, use a _Joined List_ targeting the column you just added (no separator needed): - Optional: with _Template_ colmuns, you can already add your HTML tags (in can also be done later on, I only show it to you here): - Add a _Template_ column to wrap all in a unique column: The code I used, however not especialy relevant unless you adapt it to your own case: ```HTML Title

    A sample text

    List of Fruits

    List of Colors

    ``` - `

    ` to add a paragrah (some text) - `

    `, `

    ` to `

    ` are levels for titles - `