# Qty for inventory
**URL:** https://community.glideapps.com/t/qty-for-inventory/6460
**Category:** Ask for Help
**Created:** [April 5, 2020, 4:19pm UTC](https://community.glideapps.com/t/qty-for-inventory/6460 "2020-04-05T16:19:33Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Brian\_Howard](https://community.glideapps.com/u/Brian_Howard)
#### Post date: [April 5, 2020, 4:19pm UTC](https://community.glideapps.com/t/qty-for-inventory/6460/1 "2020-04-05T16:19:33Z")
Building my first app. It’s for a in store pickup at my store. I want to add an inventory of items like 3 Mac and cheese boxes. Then when a customer add that item to their order the inventory goes down to 2 Mac and cheese boxes. Is that possible and if so could someone help me by explaining how to accomplish that. Thanks!
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [April 5, 2020, 8:25pm UTC](https://community.glideapps.com/t/qty-for-inventory/6460/2 "2020-04-05T20:25:54Z")
It is possible. I have this functionality in my app
[itemstore.glideapp.io](http://itemstore.glideapp.io)
Just have to set the initial amount. Then, do a relation to the item name in your sales sheet. Roll up the count and use a math column to subtract the count from the original total.
---
### Author:  [@Brian\_Howard](https://community.glideapps.com/u/Brian_Howard)
#### Post date: [April 5, 2020, 8:26pm UTC](https://community.glideapps.com/t/qty-for-inventory/6460/3 "2020-04-05T20:26:45Z")
Great I’ll check this out soon. Appreciate the help!
---
### Author:  [@Brian\_Howard](https://community.glideapps.com/u/Brian_Howard)
#### Post date: [April 8, 2020, 12:19am UTC](https://community.glideapps.com/t/qty-for-inventory/6460/4 "2020-04-08T00:19:18Z")
I do appreciate the help but I’m not really understanding how to do this. I’m a bit of a newbie. is there anyway I can get more of a detailed exclamation?
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [April 8, 2020, 2:11am UTC](https://community.glideapps.com/t/qty-for-inventory/6460/5 "2020-04-08T02:11:57Z")
This should help:
---
### Author:  [@Brian\_Howard](https://community.glideapps.com/u/Brian_Howard)
#### Post date: [April 8, 2020, 7:15pm UTC](https://community.glideapps.com/t/qty-for-inventory/6460/6 "2020-04-08T19:15:20Z")
Great thanks! How does this work if I want a button to be used to item that item to a list on another tab?
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [April 8, 2020, 7:57pm UTC](https://community.glideapps.com/t/qty-for-inventory/6460/7 "2020-04-08T19:57:42Z")
Hm.
Within the app, probably need a column with a form button \> checkbox attached. The other sheets can check for that column to form a relation and thus add the item.
If you want the item to show up in the Google Sheet, then instead of a relation, do a query in the other sheet that’s searching for that checkbox value.