I have created an Unfulfilled Daily Orders view that filters orders that need to be put into production (handmade beanies ) .
I need to AUTOMATICALLY create a table or view from this that summarizes the orders by SKU and the quantities needed so we can see what we need to produce. This table will look like this…
I have created this Production Required table manually using a combination of linked records and roll ups and it seems to work fine.
However, I need this to be created / updated automatically when new records appear in the Unfulfilled Daily Orders view.
I was hoping someone could suggest a way this happens automatically with an automation or scripting block script.