I don't know how much help I will be, but I have tried to use our Apps for Inventory tracking. The problem we kept running into is, someone needs to be in charge of consistently updating Quickbase. So there has a to be a consistent system where every time something is removed from a bin, placed in a bin, placed in a vehicle, removed from a vehicle, etc - there must be some way to update that in Quickbase.
It is not an easy task, especially since this relies on field personnel (assuming they have the vehicles) also updating as needed. This can be easier for big ticket items (things like tools you may be able to make qr codes, so you scan it and it perhaps takes you to a QB form and asks you, where is this item going). However, we always ran into issues because we were working with inventory such as screws, valves, gaskets, etc. We couldn't realistically tag everything. So we have abandoned the inventory tracking at the vehicle level.
I'm curious to see if anyone else chimes in, and has some good advice for this use case. We looked into stand alone inventory management software, and they are pretty amazing, but expensive. And they are very niche, so obviously only do that one task. And they still rely on bar codes on every item (which I would think is the only way to really track at all levels).
In short, for big ticket items, I would possibly consider QR codes. But those really track where the single item is located. For bulk inventory tracking, I am not sure and am curious to see what others have come up with.
