# Inventory by location
**URL:** https://community.glideapps.com/t/inventory-by-location/12985
**Category:** Ask for Help
**Created:** [July 23, 2020, 12:36pm UTC](https://community.glideapps.com/t/inventory-by-location/12985 "2020-07-23T12:36:02Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Marc\_Lanson](https://community.glideapps.com/u/Marc_Lanson)
#### Post date: [July 23, 2020, 12:36pm UTC](https://community.glideapps.com/t/inventory-by-location/12985/1 "2020-07-23T12:36:02Z")
So would really like to be able to do this on one sheet if its possible. I have a list of inventory across multiple locations, for example:
Location Item Amount
London Peaches 4
Paris Melons 3
London Apples 5
If I have this sheet linked to my tab and chose Location as the list ‘London’ displays twice, I only want it to show once and then be able to click on each location to drill down to the next level. Is there a way I can create a list based on the unique locations in my inventory list with just one sheet?
Thanks!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 23, 2020, 1:28pm UTC](https://community.glideapps.com/t/inventory-by-location/12985/2 "2020-07-23T13:28:07Z")
You create a new sheet, then use a unique function to get all unique locations. Then make a relation column matching that unique location value back to the location n, set it to match multiples.
Show that unique column in a new tab in your app, set the action to “link to screen”, use the relation value as your screen value.
---
### Author:  [@Coupons\_Deal](https://community.glideapps.com/u/Coupons_Deal)
#### Post date: [July 23, 2020, 1:40pm UTC](https://community.glideapps.com/t/inventory-by-location/12985/3 "2020-07-23T13:40:55Z")
ThinhDinh solution works well but if you really want it in one sheet then use Choice Component. This way you can reduce one drill-down as well. In Choice component, it shows unique item’s only.
Used to mention as @ThinhDinh said, column should be user-specific.
Here you can see it:
[https://towering-sail-4613.glideapp.io/](https://towering-sail-4613.glideapp.io/)
 
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 23, 2020, 2:14pm UTC](https://community.glideapps.com/t/inventory-by-location/12985/4 "2020-07-23T14:14:23Z")
That is certainly a good solution and remember to make the column user-specific to write the choice to.
---
### Author:  [@Coupons\_Deal](https://community.glideapps.com/u/Coupons_Deal)
#### Post date: [July 23, 2020, 2:30pm UTC](https://community.glideapps.com/t/inventory-by-location/12985/5 "2020-07-23T14:30:52Z")
Good Catch. I did in the demo but missed to mention 😅
---
### Author:  [@Marc\_Lanson](https://community.glideapps.com/u/Marc_Lanson)
#### Post date: [July 25, 2020, 10:06am UTC](https://community.glideapps.com/t/inventory-by-location/12985/6 "2020-07-25T10:06:36Z")
Thanks @Coupons_Deal @ThinhDinh! - Took me a while but figured out I needed to put the tab on details style to make this work. Next issue I have is that the location column can’t seem to be turned to user specific… I can see the option when I click edit on the column but it can’t be clicked. Any ideas?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 25, 2020, 10:09am UTC](https://community.glideapps.com/t/inventory-by-location/12985/7 "2020-07-25T10:09:34Z")
When he mentioned the user-specific column, he means you should have a new column, let’s say “Location choice” and make that user-specific. Show the information below that based on visisibility conditions tied to that user-specific column.
---
### Author:  [@Marc\_Lanson](https://community.glideapps.com/u/Marc_Lanson)
#### Post date: [July 25, 2020, 10:38am UTC](https://community.glideapps.com/t/inventory-by-location/12985/8 "2020-07-25T10:38:13Z")
Wonderful! Thanks I got it working.