# Creation of multiple rows dynamically

**URL:** <https://community.glideapps.com/t/creation-of-multiple-rows-dynamically/37151>\
**Category:** Ask for Help\
**Created:** [January 14, 2022, 6:24am UTC](https://community.glideapps.com/t/creation-of-multiple-rows-dynamically/37151 "2022-01-14T06:24:55Z")\
**Posts on this page:** 12\
**Page:** 2

<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:** [January 15, 2022, 12:19am UTC](https://community.glideapps.com/t/creation-of-multiple-rows-dynamically/37151/21 "2022-01-15T00:19:51Z")

</div>

> **[Method: spreadsheets.values.append  |  Sheets API  | ...](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/append)**

I use this, specifically.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/9/693dacf672223a88b7aa5ee1993198c5a2028d18.jpeg)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/3/9341036182cfaacc4ae178e7a7a6f8d9f2b498f1.png)

Built my value structure through my app and pass it via the webhook.

---

<div class="post-metadata">

**Author:** ![Tobias](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tobias/32/30930_2.png) [@Tobias](https://community.glideapps.com/u/Tobias)\
**Post date:** [January 15, 2022, 9:04am UTC](https://community.glideapps.com/t/creation-of-multiple-rows-dynamically/37151/22 "2022-01-15T09:04:59Z")

</div>

Thanks, everyone for so much input.

I came up with a solution that would work with any solution that allows to loop over a table. I used App Script.

I restructured the data to the following:  
Products & Components (id, name, type)  
Assembly (id, product id, component id, quantity)  
Production List (id, product id, quantity, status)

@Roldy your template was very helpful in re-thinking the data structure. I had not considered multiple levels of connections before.

With these 3 tables I can reach unlimited levels deep in the BOM and add an unlimited number of sub-components at each level. At the same time the table structure is pretty simple.

All I do now is send a webhook with the product ID & quantity I want to produce to my app script. That loops through the Assembly table and finds all components that need to be ordered & calculates the required quantity.

Then it writes an entry for each part that needs to be ordered/produced in the Production List.

---

<div class="post-metadata">

**Author:** ![Tobias](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tobias/32/30930_2.png) [@Tobias](https://community.glideapps.com/u/Tobias)\
**Post date:** [January 15, 2022, 11:52am UTC](https://community.glideapps.com/t/creation-of-multiple-rows-dynamically/37151/23 "2022-01-15T11:52:37Z")

</div>

It looks like there are quite a few people here who had this issue before and I assume we won’t be the last.

@ThinhDinh @Roldy @VVerhille @Darren_Murphy

Please upvote this loop action feature which would make this and similar implementation so much easier: [Looped Actions](https://community.glideapps.com/t/looped-actions/32845)

It looks like it didn’t gain much traction. Maybe because a lot of Glide users are not developers, so a loop action doesn’t mean much to them? Not sure.

But it would be great if we could generate some traction for that feature!

---

<div class="post-metadata">

**Author:** ![Roldy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roldy/32/36068_2.png) [@Roldy](https://community.glideapps.com/u/Roldy)\
**Post date:** [January 17, 2022, 8:36am UTC](https://community.glideapps.com/t/creation-of-multiple-rows-dynamically/37151/24 "2022-01-17T08:36:35Z")

</div>

Now it’s ok thanks!  
But sorry @SantiagoPerez why the maker is My Team and not Roldy?

---

<div class="post-metadata">

**Author:** ![Roldy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roldy/32/36068_2.png) [@Roldy](https://community.glideapps.com/u/Roldy)\
**Post date:** [January 17, 2022, 8:41am UTC](https://community.glideapps.com/t/creation-of-multiple-rows-dynamically/37151/25 "2022-01-17T08:41:13Z")

</div>

It is extremely complex to do everything in one row, all inside Glide of course.  
Honestly, with the tools we have today, I don’t know if I would be able to do that.  
Do you think it’s possible @gvalero ? I’ll think about it too as soon as I have a moment.

---

<div class="post-metadata">

**Author:** ![Roldy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roldy/32/36068_2.png) [@Roldy](https://community.glideapps.com/u/Roldy)\
**Post date:** [January 17, 2022, 8:49am UTC](https://community.glideapps.com/t/creation-of-multiple-rows-dynamically/37151/26 "2022-01-17T08:49:00Z")

</div>

Unfortunately, I have reached my limit of votes, and I cannot support it. Yes, it would be really useful, but I say that if it were possible to work with actions that are able to act on multiple relations, we could achieve amazing results without the need to find workarounds all the time.

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [January 17, 2022, 12:47pm UTC](https://community.glideapps.com/t/creation-of-multiple-rows-dynamically/37151/27 "2022-01-17T12:47:21Z")

</div>

This most likely the info that you have in your template. If you want your name to appear on the template store you need to go to app info settings and change your team name for your name.

---

<div class="post-metadata">

**Author:** ![Roldy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roldy/32/36068_2.png) [@Roldy](https://community.glideapps.com/u/Roldy)\
**Post date:** [January 17, 2022, 10:44pm UTC](https://community.glideapps.com/t/creation-of-multiple-rows-dynamically/37151/28 "2022-01-17T22:44:09Z")

</div>

> [@SantiagoPerez](#):
>
> you need to go to app info settings

Sorry, I can’t find this setting. App info in Pages it is different from App, here there is no section where to write the author’s name.

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [January 17, 2022, 11:57pm UTC](https://community.glideapps.com/t/creation-of-multiple-rows-dynamically/37151/29 "2022-01-17T23:57:01Z")

</div>

You are right! Type your name in the description.

---

<div class="post-metadata">

**Author:** ![Roldy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roldy/32/36068_2.png) [@Roldy](https://community.glideapps.com/u/Roldy)\
**Post date:** [January 18, 2022, 12:04am UTC](https://community.glideapps.com/t/creation-of-multiple-rows-dynamically/37151/30 "2022-01-18T00:04:32Z")

</div>

Do you mean that I’ve to submit the template again writing Roldy in the description input field?

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [January 18, 2022, 12:19am UTC](https://community.glideapps.com/t/creation-of-multiple-rows-dynamically/37151/31 "2022-01-18T00:19:46Z")

</div>

> [@Roldy](#):
>
> Honestly, with the tools we have today, I don’t know if I would be able to do that

Hola Roldy,

Let me try something when I have some free time although your requirements to have 99 levels is … 🥴 🙃

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [January 18, 2022, 12:26am UTC](https://community.glideapps.com/t/creation-of-multiple-rows-dynamically/37151/32 "2022-01-18T00:26:29Z")

</div>

You do not need to resubmit it.

I meant, next Page that you submit, type your name in the description so it gets posted on the Template store.

[Previous page](https://community.glideapps.com/t/creation-of-multiple-rows-dynamically/37151.md?page=1)
