I have built and re-built this inventory base so many times and I’m beyond frustrated. I know there is a simple solution to this. Here is what I have
Daily Used (we spread & spray these materials as a service)
Swaps (We need to swap material from truck to truck at times)
Returns (Sometimes we need to return materials to the warehouse from the truck)
Adjustments (Sometimes a few bags may be miscounted and we will need to make adjustments)
We need to keep track of how much was used each day by each truck/employee. Sometimes an employee will use a different truck.
Trucks, Employees, Materials, Locations are all synced tables from other bases and that is important.
I’ve been using Google Datastudio for many other reports. I’d like to report on the status of how much inventory is in what truck and or what location. I’m using an exporter from a shared view to copy the data out of Airtable into a google sheet.
Can someone PLEASE help me with this ? I will gladly pay to get this thing up and running. I have about 1-2 weeks before this needs to go live. I’m also looking to use forms to have employees submit orders and “daily loads”, etc.