Template
Dynamic inventory with qty
Scan items with quantities to keep a running inventory count
Industry:
n/a
Function:
Other
See the "Dynamic inventory" example app for the basics. This app extends that one to allow for quantities to be included.
Loading...
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.
Data
This is a high-level model of both the data entities and the UI elements in the app.
Loading...