We're setting up your new app...


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.

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.
Start for free