# How to write multiple rows to table?

**URL:** https://community.glideapps.com/t/how-to-write-multiple-rows-to-table/82377
**Category:** Ask for Help
**Created:** [June 10, 2025, 2:52pm UTC](https://community.glideapps.com/t/how-to-write-multiple-rows-to-table/82377 "2025-06-10T14:52:08Z")
**Posts on this page:** 19
**Page:** 1

<div class="post-metadata">

### Author: ![nboulware](https://avatars.discourse-cdn.com/v4/letter/n/db5fbb/32.png) [@nboulware](https://community.glideapps.com/u/nboulware)
#### Post date: [June 10, 2025, 2:52pm UTC](https://community.glideapps.com/t/how-to-write-multiple-rows-to-table/82377/1 "2025-06-10T14:52:09Z")

</div>

I am building an app where I can select different items for equipment that we build, it will be used to help quote our builds. I have parent/child relations set up with some of the items in my sheet. How can I add the child items to my quote table when I add the parent? I have been using chatgpt to help me, it says to use “add multiple rows” but I dont have that option available anywhere. This is the first time using this app, so I am still learning. Any input is appreciated.

---

<div class="post-metadata">

### Author: ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)
#### Post date: [June 10, 2025, 4:43pm UTC](https://community.glideapps.com/t/how-to-write-multiple-rows-to-table/82377/2 "2025-06-10T16:43:36Z")

</div>

Hi,

There is no add multiple rows in Glide at the moment. But, you have multiple ways to achieve this :

1. Use Bulk Insertion: [Bulk insert from one table to another](https://community.glideapps.com/t/bulk-insert-from-one-table-to-another/72760)  
Here is an advanced tutorial for update bulk but works the same way for insertion by changing the action type: [Bulk Edit Column Values Across Multiple Rows in Glide with User-Specific Column Compatibility](https://community.glideapps.com/t/bulk-edit-column-values-across-multiple-rows-in-glide-with-user-specific-column-compatibility/77644)
2. Use a webhook workflow or a manual workflow to access the loop feature and add rows for each element you would have in a collection.

Let me know if you need more help!

---

<div class="post-metadata">

### Author: ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)
#### Post date: [June 10, 2025, 4:44pm UTC](https://community.glideapps.com/t/how-to-write-multiple-rows-to-table/82377/3 "2025-06-10T16:44:01Z")

</div>

Welcome to this wonderful community by the way!

---

<div class="post-metadata">

### Author: ![nboulware](https://avatars.discourse-cdn.com/v4/letter/n/db5fbb/32.png) [@nboulware](https://community.glideapps.com/u/nboulware)
#### Post date: [June 10, 2025, 4:59pm UTC](https://community.glideapps.com/t/how-to-write-multiple-rows-to-table/82377/4 "2025-06-10T16:59:15Z")

</div>

Thank you. Im about to dive into that. Will both of those options work with a free account?

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 10, 2025, 10:54pm UTC](https://community.glideapps.com/t/how-to-write-multiple-rows-to-table/82377/5 "2025-06-10T22:54:17Z")

</div>

It won’t work on a free account because it either requires Call API or workflow automations, which can only be done on paid plans.

---

<div class="post-metadata">

### Author: ![nboulware](https://avatars.discourse-cdn.com/v4/letter/n/db5fbb/32.png) [@nboulware](https://community.glideapps.com/u/nboulware)
#### Post date: [June 11, 2025, 12:46am UTC](https://community.glideapps.com/t/how-to-write-multiple-rows-to-table/82377/6 "2025-06-11T00:46:16Z")

</div>

Is there a way to do it with a free account?

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 11, 2025, 12:55am UTC](https://community.glideapps.com/t/how-to-write-multiple-rows-to-table/82377/7 "2025-06-11T00:55:28Z")

</div>

Nothing easy that I can think of. Do you have a fixed set of “template” children for each parent? Maybe you can get away with multiple add row steps, but that feels clunky.

---

<div class="post-metadata">

### Author: ![nboulware](https://avatars.discourse-cdn.com/v4/letter/n/db5fbb/32.png) [@nboulware](https://community.glideapps.com/u/nboulware)
#### Post date: [June 11, 2025, 1:04am UTC](https://community.glideapps.com/t/how-to-write-multiple-rows-to-table/82377/8 "2025-06-11T01:04:31Z")

</div>

Yes, I do.

Ive been trying to figure out the logic to do that.

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 11, 2025, 1:15am UTC](https://community.glideapps.com/t/how-to-write-multiple-rows-to-table/82377/9 "2025-06-11T01:15:08Z")

</div>

What’s your flow looking like in your app right now?

---

<div class="post-metadata">

### Author: ![nboulware](https://avatars.discourse-cdn.com/v4/letter/n/db5fbb/32.png) [@nboulware](https://community.glideapps.com/u/nboulware)
#### Post date: [June 11, 2025, 1:24am UTC](https://community.glideapps.com/t/how-to-write-multiple-rows-to-table/82377/10 "2025-06-11T01:24:27Z")

</div>

![workflow](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/0/900485ec917e495233218188db81740dd7abff8c.jpeg)  
 ![data](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/b/ab989e166f4a6d891f6d3900b35f7de73cea1c0a.jpeg)

Here is a screenshot of my current workflow. Also included a section of my data table so you can see where its pulling from.

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 11, 2025, 1:25am UTC](https://community.glideapps.com/t/how-to-write-multiple-rows-to-table/82377/11 "2025-06-11T01:25:51Z")

</div>

So what does “CHILD COMP” mean in your flow?

For each quote added, you want to add some template items for that quote, is that correct?

---

<div class="post-metadata">

### Author: ![nboulware](https://avatars.discourse-cdn.com/v4/letter/n/db5fbb/32.png) [@nboulware](https://community.glideapps.com/u/nboulware)
#### Post date: [June 11, 2025, 1:29am UTC](https://community.glideapps.com/t/how-to-write-multiple-rows-to-table/82377/12 "2025-06-11T01:29:56Z")

</div>

![data1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/3/638d543645c88431e22b69bbc02dd58657916bdf.jpeg)

Sorry, didnt copy all my data. I set that column up as a relation. It list all of the child items associated with that parent item.

---

<div class="post-metadata">

### Author: ![nboulware](https://avatars.discourse-cdn.com/v4/letter/n/db5fbb/32.png) [@nboulware](https://community.glideapps.com/u/nboulware)
#### Post date: [June 11, 2025, 1:31am UTC](https://community.glideapps.com/t/how-to-write-multiple-rows-to-table/82377/13 "2025-06-11T01:31:16Z")

</div>

My goal is to be able to pick what items add to my quote and it any item has child items it will add them automatically.

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 11, 2025, 1:42am UTC](https://community.glideapps.com/t/how-to-write-multiple-rows-to-table/82377/14 "2025-06-11T01:42:37Z")

</div>

So there can be multiple items in a quote, and then all children items must be added to that quote as well?

Do you anticipate those children items be changed, for any fields, in the future?

---

<div class="post-metadata">

### Author: ![nboulware](https://avatars.discourse-cdn.com/v4/letter/n/db5fbb/32.png) [@nboulware](https://community.glideapps.com/u/nboulware)
#### Post date: [June 11, 2025, 1:47am UTC](https://community.glideapps.com/t/how-to-write-multiple-rows-to-table/82377/15 "2025-06-11T01:47:01Z")

</div>

> [@ThinhDinh](#):
>
> o there can be multiple items in a quote, and then all children items must be added to that quote as well?

That is correct. There will be multiple items added to quote. Yes, child items added to quote. I am basically build a materials list to quote equipment we build.

I dont see any of the fields changing, just adding/updating items.

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 11, 2025, 1:49am UTC](https://community.glideapps.com/t/how-to-write-multiple-rows-to-table/82377/16 "2025-06-11T01:49:32Z")

</div>

I think you might be able to get away with storing the children items as a JSON object.

Is there any reason you have to get them into rows other than making the structure clean? Do you need to edit the items/children items in a quote after the first add?

---

<div class="post-metadata">

### Author: ![nboulware](https://avatars.discourse-cdn.com/v4/letter/n/db5fbb/32.png) [@nboulware](https://community.glideapps.com/u/nboulware)
#### Post date: [June 11, 2025, 2:08am UTC](https://community.glideapps.com/t/how-to-write-multiple-rows-to-table/82377/17 "2025-06-11T02:08:19Z")

</div>

No, there shouldn’t be any need to edit the items once they are added. The only reason I was trying to add a row is because thats all I knew how to do. As long as I can get the data in the quote table it shouldn’t matter how its accomplished.

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 11, 2025, 11:29pm UTC](https://community.glideapps.com/t/how-to-write-multiple-rows-to-table/82377/18 "2025-06-11T23:29:13Z")

</div>

If it isn’t too much for you to set up, and assuming children items are not edited for a quote, I would recommend this:

- Add a JSON object column to your children table and construct a JSON that includes all relevant fields.
- Add a multiple relations column in your quote table that relates to all children items.
- Add a joined list column to join all related JSON objects, separated by a comma and a newline character.
- Add a template column:

```auto
[
{joinedJSON}
]

```

With joinedJSON being the value from the step above, to make it a valid JSON array.

- Add a childrenJSON text column, and on submit of any quotes, write the joinedJSON to childrenJSON to lock it in.

I’m not sure what further things you would do with childrenJSON so I leave it there.

I would suggest trying the Explorer plan when you get a chance. You have access to the Workflows on that plan to make this easier.

---

<div class="post-metadata">

### Author: ![nboulware](https://avatars.discourse-cdn.com/v4/letter/n/db5fbb/32.png) [@nboulware](https://community.glideapps.com/u/nboulware)
#### Post date: [June 12, 2025, 1:47am UTC](https://community.glideapps.com/t/how-to-write-multiple-rows-to-table/82377/19 "2025-06-12T01:47:19Z")

</div>

Thank you. I am going to read up on this and see what I can figure out.
