New to Airtable and looking for help setting up asset tracking!


#1

Hi there!

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!

Scenario:
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!!
H


#2

Hi,

This is something that is well within my area of expertise and I would be glad to help you out.
You can reach me on andrewjohnson56782@gmail.com

Best Wishes,
Andrew


#3

Hello

I can help you with it

Kindly connect james.kevinn