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!
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.
1 Like
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/
1 Like
That is certainly a good solution and remember to make the column user-specific to write the choice to.
2 Likes
Good Catch. I did in the demo but missed to mention 
2 Likes
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?
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.
Wonderful! Thanks I got it working.
1 Like
