New Example App: Inventory Manager

04/11/2014 Posted by Brandon

We’ve released a new example app for managing inventory:

https://www.knack.com/inventory-manager/

This app really shows off Knack’s equation and formula fields, as well as a conditional field.

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”.
Knack users can add this new app directly from the dashboard.