# Updated quantities

**URL:** <https://community.glideapps.com/t/updated-quantities/26539>\
**Category:** Ask for Help\
**Created:** [May 8, 2021, 1:45am UTC](https://community.glideapps.com/t/updated-quantities/26539 "2021-05-08T01:45:20Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Augusto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/augusto/32/25004_2.png) [@Augusto](https://community.glideapps.com/u/Augusto)\
**Post date:** [May 8, 2021, 1:45am UTC](https://community.glideapps.com/t/updated-quantities/26539/1 "2021-05-08T01:45:20Z")

</div>

I have two Glidetables:

1. List of products with started quantities;
2. A management list of products that were sold with the quantities that were purchased.

I wanted the updated quantities of from the management table to my products list.  
How can I do this?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [May 8, 2021, 2:00am UTC](https://community.glideapps.com/t/updated-quantities/26539/2 "2021-05-08T02:00:03Z")

</div>

Assuming that your tables look something like…

- Products

- Sales

…then…

- Create a multi-relation _from_ your Products table to your Sales table, joining `Products.SKU` to `Sales.Product SKU`
- Create a Rollup column that takes the Sum of Qty from that multi-relation
- Use a Math column to calculate the “Current Balance” by subtracting the result of the Rollup column from the Starting Qty

---

<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:** [May 8, 2021, 2:03am UTC](https://community.glideapps.com/t/updated-quantities/26539/3 "2021-05-08T02:03:48Z")

</div>

Yes, you can but one by one.

There is no a way to update multiple items (rows) at the same time. The Set Column action doesn’t support a multiple relation unfortunately yet.

But using a GS the story is different.

Saludos

---

<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:** [May 8, 2021, 2:12am UTC](https://community.glideapps.com/t/updated-quantities/26539/4 "2021-05-08T02:12:54Z")

</div>

I think @Darren_Murphy and me are using different methods to update items 🤣

In my case, I want to have a final amount without counting and reviewing your historical sales data.

Saludos

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [May 8, 2021, 2:16am UTC](https://community.glideapps.com/t/updated-quantities/26539/5 "2021-05-08T02:16:22Z")

</div>

hmm… did I misunderstand the question?  
If I did, it’s because I just woke up and haven’t had my morning Milo yet.  
That’s my excuse, and I’m sticking with it 😛 🤣

---

<div class="post-metadata">

**Author:** ![Augusto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/augusto/32/25004_2.png) [@Augusto](https://community.glideapps.com/u/Augusto)\
**Post date:** [May 8, 2021, 11:50pm UTC](https://community.glideapps.com/t/updated-quantities/26539/6 "2021-05-08T23:50:18Z")

</div>

Thanks to all replys.

@Darren_Murphy  
How do I joing Products.SKU to Sales.Products.SKU?  
I haven’t done any multirelations yet

---

<div class="post-metadata">

**Author:** ![Augusto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/augusto/32/25004_2.png) [@Augusto](https://community.glideapps.com/u/Augusto)\
**Post date:** [May 9, 2021, 1:59am UTC](https://community.glideapps.com/t/updated-quantities/26539/7 "2021-05-09T01:59:49Z")

</div>

I got it @Darren_Murphy.

At **Sales** :

- Template → SKU:PRODUCT\_NAME.

At **Products List** :

- Template Column → SKU:PRODUCT\_NAME;
- Relation Column: TMP\_SKU → Sales TMP\_SKU, check Match Multiple;
- Rollup Column: Relation Column with QTD, Sum option;
- Math Column: QTD - Rollup;

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [May 9, 2021, 2:24am UTC](https://community.glideapps.com/t/updated-quantities/26539/8 "2021-05-09T02:24:11Z")

</div>

Good job! 👍