Dynamic inventory with qty
Scan items with quantities to keep a running inventory count
See the "Dynamic inventory" example app for the basics. This app extends that one to allow for quantities to be included.
Also see: tablet mode & fullscreen mode
How we built this app
We extended the basic example by adding a Quantity column to the Purchases and Sales tables. Then, we added three virtual columns to the Product table. Total Purchases: SUM(SELECT([Related Purchases][Quantity], true)) Total Sales: SUM(SELECT([Related Sales][Quantity], true)) Current Stock: [Total Purchases] - [Total Sales]
This is a preview of the data sets used in the app.
This is a high-level model of both the data entities and the UI elements in the app.