# Increment Issue!

**URL:** <https://community.glideapps.com/t/increment-issue/34231>\
**Category:** Ask for Help\
**Created:** [November 9, 2021, 2:01am UTC](https://community.glideapps.com/t/increment-issue/34231 "2021-11-09T02:01:21Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Conner\_Krofchick1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/conner_krofchick1/32/27182_2.png) [@Conner\_Krofchick1](https://community.glideapps.com/u/Conner_Krofchick1)\
**Post date:** [November 9, 2021, 2:01am UTC](https://community.glideapps.com/t/increment-issue/34231/1 "2021-11-09T02:01:22Z")

</div>

Hi Everyone,

I have been working on an app but have gotten stuck on the increment function. My app is separated into two sheets. One sheet is where orders comes in listing all the orders. The other sheet is the inventory of the product.

On the app I have a page using the order sheet that allows me to approve the order. When I approve the order I would like to decrement by the quantity of the order on the inventory page.

The problem I am facing is they are two separate sheets and I guess I cannot increment from one sheet to another sheet.

Does anyone know any work arounds or solutions??

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [November 9, 2021, 2:05am UTC](https://community.glideapps.com/t/increment-issue/34231/2 "2021-11-09T02:05:39Z")

</div>

If you create a single relation that links the item in the order sheet to the item in the inventory sheet, then you can set column values through that relation. I don’t remember offhand if the increment action works through a single relation, but if it doesn’t, then you can create a single value or lookup column in the order sheet that pulls the current inventory from from that single relation. Then create a math column to subtract the number of items that were ordered, then send that math value using a set column action through the relation back to the inventory sheet to update it.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [November 9, 2021, 2:07am UTC](https://community.glideapps.com/t/increment-issue/34231/3 "2021-11-09T02:07:36Z")

</div>

Just wait. Increment via relation is finally coming to Glide (it’s in staging now).

---

<div class="post-metadata">

**Author:** ![Conner\_Krofchick1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/conner_krofchick1/32/27182_2.png) [@Conner\_Krofchick1](https://community.glideapps.com/u/Conner_Krofchick1)\
**Post date:** [November 9, 2021, 2:16am UTC](https://community.glideapps.com/t/increment-issue/34231/4 "2021-11-09T02:16:41Z")

</div>

Thank you Jeff, Much appreciated!

---

<div class="post-metadata">

**Author:** ![Conner\_Krofchick1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/conner_krofchick1/32/27182_2.png) [@Conner\_Krofchick1](https://community.glideapps.com/u/Conner_Krofchick1)\
**Post date:** [November 9, 2021, 2:17am UTC](https://community.glideapps.com/t/increment-issue/34231/5 "2021-11-09T02:17:40Z")

</div>

Really!! Do you know if this is something coming in the next month or so or is it still a couple months out?

---

<div class="post-metadata">

**Author:** ![Conner\_Krofchick1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/conner_krofchick1/32/27182_2.png) [@Conner\_Krofchick1](https://community.glideapps.com/u/Conner_Krofchick1)\
**Post date:** [November 9, 2021, 2:20am UTC](https://community.glideapps.com/t/increment-issue/34231/6 "2021-11-09T02:20:00Z")

</div>

Also, Love your videos!

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [November 9, 2021, 2:42am UTC](https://community.glideapps.com/t/increment-issue/34231/7 "2021-11-09T02:42:28Z")

</div>

I bet it hits this week. If it’s already in staging, it should be out by Thursday is my guess.

---

<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:** [November 9, 2021, 3:02am UTC](https://community.glideapps.com/t/increment-issue/34231/8 "2021-11-09T03:02:13Z")

</div>

Thursday is always my favorite day of the week haha.
