# Add a new row to another table based on value of an existing Table (Confused with Grouping)

**URL:** <https://connect.superhuman.com/t/add-a-new-row-to-another-table-based-on-value-of-an-existing-table-confused-with-grouping/15740>\
**Category:** Ask the Community\
**Created:** [May 7, 2020, 10:37am UTC](https://connect.superhuman.com/t/add-a-new-row-to-another-table-based-on-value-of-an-existing-table-confused-with-grouping/15740 "2020-05-07T10:37:24Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![M\_Hermi](https://avatars.discourse-cdn.com/v4/letter/m/7ab992/32.png) [@M\_Hermi](https://connect.superhuman.com/u/M_Hermi)\
**Post date:** [May 7, 2020, 10:37am UTC](https://connect.superhuman.com/t/add-a-new-row-to-another-table-based-on-value-of-an-existing-table-confused-with-grouping/15740/1 "2020-05-07T10:37:24Z")

</div>

Hello Everyone,

I am trying to add a new row to another table based on value of an existing Table.

What users of the doc must be able to do is :

1. Choose the Purchase Requisition (PR) that he/she wants to add the items from Catalog of Items

2. Users will then select the items to add into the selected Purchase Requisition from the **Catalog of Items** Table  
a) If PR has no items added yet it will not be shown under **All Purchase Request** Table  
b) When a user starts to increase quantity of an item it will be added to the **All Purchase Request** Table.

I’ve been trying to figure it out but i am still confused on how to create formulas when grouping of rows is involved.

Below is the screenshot of my doc for your reference

Thank you very much

 ![Screenshot 2020-05-07 at 5.16.02 PM](https://global.discourse-cdn.com/coda1/original/2X/b/bb30c39064a727988a8bc7db19b030b68ba0899a.png)

---

<div class="post-metadata">

**Author:** ![M\_Hermi](https://avatars.discourse-cdn.com/v4/letter/m/7ab992/32.png) [@M\_Hermi](https://connect.superhuman.com/u/M_Hermi)\
**Post date:** [May 8, 2020, 1:25am UTC](https://connect.superhuman.com/t/add-a-new-row-to-another-table-based-on-value-of-an-existing-table-confused-with-grouping/15740/2 "2020-05-08T01:25:07Z")

</div>

After working around the table formulas i still haven’t found the solutions to the problem mentioned above

https://coda.io/embed/fSX_egBUHf/_suyUA?viewMode=embedplay

---

<div class="post-metadata">

**Author:** ![steph](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/steph/32/20983_2.png) [@steph](https://connect.superhuman.com/u/steph)\
**Post date:** [October 5, 2021, 5:54pm UTC](https://connect.superhuman.com/t/add-a-new-row-to-another-table-based-on-value-of-an-existing-table-confused-with-grouping/15740/3 "2021-10-05T17:54:53Z")

</div>



---

<div class="post-metadata">

**Author:** ![steph](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/steph/32/20983_2.png) [@steph](https://connect.superhuman.com/u/steph)\
**Post date:** [October 7, 2021, 4:18pm UTC](https://connect.superhuman.com/t/add-a-new-row-to-another-table-based-on-value-of-an-existing-table-confused-with-grouping/15740/4 "2021-10-07T16:18:14Z")

</div>



---

<div class="post-metadata">

**Author:** ![steph](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/steph/32/20983_2.png) [@steph](https://connect.superhuman.com/u/steph)\
**Post date:** [October 7, 2021, 9:39pm UTC](https://connect.superhuman.com/t/add-a-new-row-to-another-table-based-on-value-of-an-existing-table-confused-with-grouping/15740/5 "2021-10-07T21:39:08Z")

</div>