Inventory Management
  • 21 Feb 2024
  • 2 Minutes to read
  • Contributors

Inventory Management


Article Summary

To download the app, visit: Library

Learn how the Inventory management application is structured and built.

The user can manage and view inventory items in the Inventory management application. The application stores inventory data in a Tulip Table. In the application, the data from this Tulip Table is displayed. The user can also choose to manipulate the data according to the changes on the shop floor.

Tables Used

The Tulip Table used in the application is called Inventory. Each record in the inventory table is an inventory item specified by the name, location, and status of the item. For example, you can have bricks, at the first station, reserved for a project. Each of these records has a QTY field where the user can track how many items are present in the specified location and state.

Fields of Table:

  • ID: Unique ID of the inventory item created by the concatenation of the name, the location, and the status of the item
  • Item: The name of the item
  • Area: The area where the item is located
  • Location: The exact location in the specified area
  • Status: The status of the inventory item. Can be “Available”, “Quarantined” or “Reserved”
  • QTY: The quantity of the items

App structure

The Main step of the inventory management application functions as the navigation page of the app. There are six actions you can choose from:

  1. Filter inventory items based on ID, Item nem, Location, and Status
  2. Create a new inventory item
  3. Add items to an existing inventory record
  4. Remove items from an existing inventory record
  5. Edit the status of some items from an inventory record
  6. Move some items to a different location

inventorymain.png

By clicking the Create inventory item button on the Main step, the app navigates the user to the Create Inventory Item step. In this step, the user needs to fill out all the fields and create a new inventory item by clicking on the Create button.
Screenshot 2024-02-06 at 14.34.43.png

By clicking the Add QTY button on the Main step, the app navigates the user to the Add QTY step. The user needs to type in the number of additional items and update the table record by clicking on the Add QTY button.

Screenshot 2024-02-06 at 14.34.14.png

By clicking the Remove QTY button on the Main step, the app navigates the user to the Remove QTY step. The user needs to type in the number of items to remove and update the table record by clicking on the Remove QTY button.
Screenshot 2024-02-06 at 14.34.21.png

By clicking the Edit status button on the Main step, the app navigates the user to the Edit Status step. The user must specify how many items they want to change their status and what the new status should be. They save the changes by clicking the Edit Status button.

Screenshot 2024-02-06 at 14.34.35.png

By clicking the Move QTY button on the Main step, the app navigates the user to the Move QTY step. To move items from one location to another, the user must enter how many items they would like to move and specify the new area and location.

Screenshot 2024-02-06 at 14.34.28.png


Was this article helpful?