Automation/action to add quantities?
I'm trying to create an action or an automation that will modify a record and add a new quantity to an existing quantity, rather than just replacing the old number with the new one. So, when we ma...
Forum Discussion
If you have a relationship between the Order and the Inventory tables, you should be able to use Summary fields to do this for you. I would suggest having a more robust table structure, though. Orders, Order Line Items, and Products, setup so that Orders and Products are both parent tables to Order Line Items, will give you the needed structure to do a summary field from Line Items to the Products so that you can automatically see the Quantity