I work for a cleaning company and we are trying to find a better way to manage our cleaning supply inventory better. We currently have a complicated situation where our cleaners need to notify us when they need cleaning supplies, we then move it to a master list, and then onto a distribution list.
Cleaners often will forget to ask for a product and are in need of something so they’ll ask to grab something the day of. This always messes with our ordering process as sometimes it will be so busy when they come in, we forget to mark it down and we’ll run out of products faster than expected.
Wondering if there is a way through airtable to scan the barcode and have it automatically subtract one from the master inventory.