# How to automatically create a new row in as separate table for each item in an array in a given table?

**URL:** <https://community.glideapps.com/t/how-to-automatically-create-a-new-row-in-as-separate-table-for-each-item-in-an-array-in-a-given-table/63784>\
**Category:** Ask for Help\
**Created:** [July 11, 2023, 5:30pm UTC](https://community.glideapps.com/t/how-to-automatically-create-a-new-row-in-as-separate-table-for-each-item-in-an-array-in-a-given-table/63784 "2023-07-11T17:30:09Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![meg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/meg/32/61386_2.png) [@meg](https://community.glideapps.com/u/meg)\
**Post date:** [July 11, 2023, 5:30pm UTC](https://community.glideapps.com/t/how-to-automatically-create-a-new-row-in-as-separate-table-for-each-item-in-an-array-in-a-given-table/63784/1 "2023-07-11T17:30:09Z")

</div>

I have three tables. Business Activities which contains a column with an array of items found in a second table called Pressures. I would like to automatically create, in a third table called Measures, a row for each of the items in the array along with the Row ID for the related Business Activity. Any suggestions on an approach? I am not a coder, so hoping to use Glide native capabilities. Thanks!

---

<div class="post-metadata">

**Author:** ![meg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/meg/32/61386_2.png) [@meg](https://community.glideapps.com/u/meg)\
**Post date:** [July 11, 2023, 9:53pm UTC](https://community.glideapps.com/t/how-to-automatically-create-a-new-row-in-as-separate-table-for-each-item-in-an-array-in-a-given-table/63784/2 "2023-07-11T21:53:47Z")

</div>

Never mind! I took a different approach. (But if there is a relatively easy solution, I would be interested to know.

---

<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:** [July 11, 2023, 11:59pm UTC](https://community.glideapps.com/t/how-to-automatically-create-a-new-row-in-as-separate-table-for-each-item-in-an-array-in-a-given-table/63784/3 "2023-07-11T23:59:05Z")

</div>

> [@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)

Sounds like a use case for the miracle method.

---

<div class="post-metadata">

**Author:** ![meg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/meg/32/61386_2.png) [@meg](https://community.glideapps.com/u/meg)\
**Post date:** [July 12, 2023, 12:10am UTC](https://community.glideapps.com/t/how-to-automatically-create-a-new-row-in-as-separate-table-for-each-item-in-an-array-in-a-given-table/63784/4 "2023-07-12T00:10:53Z")

</div>

Thanks @ThinhDinh ! I saw that and was scared by it. 😱

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [July 13, 2023, 12:11am UTC](https://community.glideapps.com/t/how-to-automatically-create-a-new-row-in-as-separate-table-for-each-item-in-an-array-in-a-given-table/63784/5 "2023-07-13T00:11:42Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.