My Inventory
Budget: $30 – $250 USD
I have 20 products that I loan out to clients (will eventually add more) at no cost. I need a simple way to track my inventory to show me what is loaned out and what is available. I prefer google docs and use a google form to check out a product and check a product back in. The form submission should update the overall inventory data.
EX: Using a google form to check out product CPO1001 to a David Brown on 9-30-21.
Date Product Customer Status
9-30-21 CPO1001 David Brown Out
When David Brown returns the product, we would use a google form to check the item back in:
Date Product Customer Status
10-1-21 CPO1001 David Brown Available
The most current view would now show Product CPO1001 as available. Whatever the most recent transaction should be the current status for the product. Having a clean list to quickly and easily distinguish which products are available is most important. A dashboard view would be nice, but not an absolute requirement.
EX: Using a google form to check out product CPO1001 to a David Brown on 9-30-21.
Date Product Customer Status
9-30-21 CPO1001 David Brown Out
When David Brown returns the product, we would use a google form to check the item back in:
Date Product Customer Status
10-1-21 CPO1001 David Brown Available
The most current view would now show Product CPO1001 as available. Whatever the most recent transaction should be the current status for the product. Having a clean list to quickly and easily distinguish which products are available is most important. A dashboard view would be nice, but not an absolute requirement.