Hi, I’m using AppSheet to track the loading and unloading in a warehouse. As shown in the picture
I load a number of items into a numbered location, and I can load the same code in various locations. I would like to add, below ‘total stock available,’ a list of all the locations where that product is currently present. As you can see from the picture, from position A03, I loaded 100 pieces and unloaded 100 pieces, so the position is currently empty. On the other hand, A01 and A02 are full of that product.
Thank you in advance for any help.
you need to add a new virtual column may be with name : stock available locations .
you need to pull the list of values (locations ) where stock is available.
expression may be
SELECT( table name[location], [stock] > 0)
kindly change the names of the columns in expression according to your table structure. If you need help with this please share the table structure and other details where you want to display stock available locations.
1 Like
Dear Giaichith
first of all thanks for your reply, it’s quite perfect. If I put >0 it results only the amount higher than zero, but I need a sum for each code. It doesn’t consider the negative amounts ( the decreased quantities). please see the attachements.
position A-03 should be zero , so it should not appear.
