# Items in Array to separate row in another table
**URL:** https://community.glideapps.com/t/items-in-array-to-separate-row-in-another-table/74193
**Category:** Ask for Help
**Created:** [June 18, 2024, 2:22am UTC](https://community.glideapps.com/t/items-in-array-to-separate-row-in-another-table/74193 "2024-06-18T02:22:34Z")
**Posts on this page:** 18
**Page:** 1
### Author:  [@Tally](https://community.glideapps.com/u/Tally)
#### Post date: [June 18, 2024, 2:22am UTC](https://community.glideapps.com/t/items-in-array-to-separate-row-in-another-table/74193/1 "2024-06-18T02:22:34Z")
Back again!
I read relevant posts to my problem below, but have not had these methods work
Problem:
I want a lookup/query/relationship/formula (I don’t know what the preferred method is) to extract Array column values in ‘table 1’ cell and create ‘table 2’ rows.
Table 1 Array column snip:
Context here - Each row is a receipt. Each receipt is unique and identifiable to a user & rowID
Table 2 Desired outcome (SUPPORT NEEDED):
Create a row for every array item. For example ‘Unie Sauce Chili’ should be a row & ‘Green Lentils’ should be a row, and so on. Once all items are in a separate row then the next receipt will begin filling rows. all items will be related back to a receipt in table 1 and the rowID.
Let me know how I can kickstart this process, cheers!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 19, 2024, 12:19am UTC](https://community.glideapps.com/t/items-in-array-to-separate-row-in-another-table/74193/2 "2024-06-19T00:19:08Z")
How did you populate the array in table 1 in the first place?
---
### Author:  [@Tally](https://community.glideapps.com/u/Tally)
#### Post date: [June 19, 2024, 12:31am UTC](https://community.glideapps.com/t/items-in-array-to-separate-row-in-another-table/74193/3 "2024-06-19T00:31:34Z")
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 19, 2024, 12:33am UTC](https://community.glideapps.com/t/items-in-array-to-separate-row-in-another-table/74193/4 "2024-06-19T00:33:56Z")
So the item\_name column is a JSON query?
---
### Author:  [@Tally](https://community.glideapps.com/u/Tally)
#### Post date: [June 19, 2024, 12:45am UTC](https://community.glideapps.com/t/items-in-array-to-separate-row-in-another-table/74193/5 "2024-06-19T00:45:24Z")
Yes item\_name is JSON query
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 19, 2024, 12:46am UTC](https://community.glideapps.com/t/items-in-array-to-separate-row-in-another-table/74193/6 "2024-06-19T00:46:47Z")
Does it have to be a JSON query for this to work though? Going back a further step, how was the original JSON created? This eventually will lead you to a situation where you have to use the Glide API/Call API action to add mutliple rows, so I have to make sure I understand how it’s created in the first place.
---
### Author:  [@Tally](https://community.glideapps.com/u/Tally)
#### Post date: [June 19, 2024, 1:00am UTC](https://community.glideapps.com/t/items-in-array-to-separate-row-in-another-table/74193/7 "2024-06-19T01:00:34Z")
Currently: Scanned Receipt (image)\>AI\>JSON\>JSON query.
Is the Glide API/Call API action to add multiple rows simpler?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 19, 2024, 1:01am UTC](https://community.glideapps.com/t/items-in-array-to-separate-row-in-another-table/74193/8 "2024-06-19T01:01:12Z")
> [@Tally](#):
>
> Is the Glide API/Call API action to add multiple rows simpler?
They are the only ways to do that for now.
Please have a watch here.
[ ](https://www.youtube.com/watch?v=b7_k3_brusQ)
---
### Author:  [@Tally](https://community.glideapps.com/u/Tally)
#### Post date: [June 19, 2024, 1:06am UTC](https://community.glideapps.com/t/items-in-array-to-separate-row-in-another-table/74193/9 "2024-06-19T01:06:34Z")
I will give this a try!
---
### Author:  [@Tally](https://community.glideapps.com/u/Tally)
#### Post date: [June 27, 2024, 3:52am UTC](https://community.glideapps.com/t/items-in-array-to-separate-row-in-another-table/74193/10 "2024-06-27T03:52:37Z")
This video is helpful, but as a follow up:
I have a glide maker subscription and do not have access to the glide API being used. I cannot rationalize getting an upgrade just for API access. is there an alternative method, or integration to externally do this?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 27, 2024, 4:13am UTC](https://community.glideapps.com/t/items-in-array-to-separate-row-in-another-table/74193/11 "2024-06-27T04:13:37Z")
> **[Make | Glide Docs](https://www.glideapps.com/docs/automation/integrations/make)**
>
> Integrate 1600+ tools with your app.
---
### Author:  [@MrTechSolutions](https://community.glideapps.com/u/MrTechSolutions)
#### Post date: [July 16, 2024, 10:40pm UTC](https://community.glideapps.com/t/items-in-array-to-separate-row-in-another-table/74193/12 "2024-07-16T22:40:08Z")
But when we have array? How to do it?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 16, 2024, 11:12pm UTC](https://community.glideapps.com/t/items-in-array-to-separate-row-in-another-table/74193/13 "2024-07-16T23:12:29Z")
So you want to display them as different rows in another table? Or do you want to do something else?
---
### Author:  [@MrTechSolutions](https://community.glideapps.com/u/MrTechSolutions)
#### Post date: [July 16, 2024, 11:22pm UTC](https://community.glideapps.com/t/items-in-array-to-separate-row-in-another-table/74193/14 "2024-07-16T23:22:18Z")
Each array position into new line in another table.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 16, 2024, 11:25pm UTC](https://community.glideapps.com/t/items-in-array-to-separate-row-in-another-table/74193/15 "2024-07-16T23:25:55Z")
> [@fishbaguette\_breadbasket Transpose Columns to an Inline List: The Miracle Method](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766):
>
> 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] ](https://www.youtube.com/watch?v=t-sh_Q3WbQc)
If you only need them for temporary use, please do this.
If not, please describe your case more so we can follow.
---
### Author:  [@Curtis](https://community.glideapps.com/u/Curtis)
#### Post date: [March 14, 2025, 3:51pm UTC](https://community.glideapps.com/t/items-in-array-to-separate-row-in-another-table/74193/16 "2025-03-14T15:51:02Z")
We’re trying to do something similar.
The user enters a quote request in a table and lists the items in the quote using a choice component. Ideally We’d then like to automatically list the individual items in separate rows in another table so we can put specific feedback against each item. So we’d end up with a table of items, not unique rows just per item but unique rows per item per quote.
Any ideas?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 14, 2025, 11:51pm UTC](https://community.glideapps.com/t/items-in-array-to-separate-row-in-another-table/74193/17 "2025-03-14T23:51:37Z")
With webhook triggers and loops, you can do it like this, as an on-submit action:
- Add a webhook workflow, copy the webhook URL.
- Add an on-submit action, use a trigger webhook action and send over the rowID of the quote request, and the comma-delimited list of items.
- Use two query steps to query the request ID and the items list from the body of webhook payload.
- Use a split text module to split the list of items.
- Loop through that, and add them to your helper table of items, with the same request ID for each row.
---
### Author:  [@Curtis](https://community.glideapps.com/u/Curtis)
#### Post date: [March 17, 2025, 11:35am UTC](https://community.glideapps.com/t/items-in-array-to-separate-row-in-another-table/74193/18 "2025-03-17T11:35:36Z")
Thanks, we’ll give it a go.