Is there somewhere i can find a prebuilt Inventory app with Multiple locations. I am struggling to build my own and haven’t found many helpful videos.
For a multiple location inventory app, the typical sticking point is that you need to add another table. Assuming you start with a table of items, and a table of locations, you then need a table of item_at_location which contains a record for every possible combination of item vs location.
2 Likes
I have accomplished multiple tables with the inventory items. I tried to create a master inventory page which does show me all inventory items from every location but i have not been able to figure out how to use a formula to pull the information from the other sheets to the master sheet.
My inventory app is build for only 3 locations, that has the same items, and different employees
The structure is
Orders table, that includes a [location] column , autocompleted based on useremail () , but it can also be a dropdown list easily.
Order details, referenced to Orders, and contains columns like [order id], [item], [quantity] , [in or out] , and [location] autocompleted from [order id].[location]
Items table, from wich is created the dropdown in order details with Valid If. It contains a single physical column [item] , and 3 virtual columns,one for each location . In the virtual columns I used formulas to calculate the quantity still in stock, based on order details table
1 Like
Is there any chance you would send me a copy of what you have done? I am trying to build this app but I do not understand how to use the formulas yet. Having something to work backwards from would be very helpful.
No, it’s too big and can’t clone it easily (over 20 tables,..it’s more than an inventory app at the moment). At least not this week