I have a Base where we get new orders come through on one table. We then pick products to add tot the order afterwards, and do that in new fields to the right. Item 1 as a field, Item 2 as a field etc. I’m trying to work out how I can do a stock count on another table to keep tracking of how many of each product I’m allocating (so I dont run out!) But can’t work out how!
I would normally just do a count function with a lookup of the product if I was in a normal spreadsheet but lost as to how to do it here! THanks!