We’ve released a new example app for managing inventory:
Here’s how it works:
- Both incoming purchases and outgoing orders are added to the database. Formula fields are used to sum the totals of all purchases and orders for each product.
- An equation is used to subtract orders and add purchases from a “starting inventory” to calculate the “current inventory”.
- A conditional field compares the current inventory with a “minimum required’ number. If the current inventory dips below that minimum required, “needs reorder” is set to “Yes”.