I’m looking for help in setting up a system in Airtable by which I can track assets for my VERY small business as a personal chef. My db skills are rusty at best, but I can learn!
Personal chef service uses reusable/returnable containers for packaging meals. With each delivery, I drop off the current meals and pick up the containers from the previous delivery. Containers get lost in the aether and I end up with many missing and having to purchase more (which eats into my slim profits!)
What I’d like to do:
Assign unique barcode to each client and each container.
Assign containers to a specific client via barcode scanning (scan the customer barcode; scan the container)
Scan container barcodes upon their return to see which containers are still checked-out and to whom.
Container records can contain the following fields:
Container type, size, manufacturer, supplier, purchase date, purchase price, replacement price, assigned client, condition
If you can assist with this, I would be very grateful! Thanks!!