I need to track a set of items that are received in one location and then moved to other locations. Each location receives from the main and/or each other. Each location decrements as well. I need to keep track of the quantity that is moved from the main location to all of the others, decremented from those locations and keep overall total quantity updated. Can anyone help?
Thank you so much for sending me a link to your base!
After taking a look at I recommend restructuring your base to take advantage of the Airtable’s ability to represent a many-to-many relationship because I think it will help with your quantity tracking problem.
For your specific scenario I created a simplified version of your base that I think should be able to cover the functionality you are looking for. I created three tables: