I’ll try to make it simple:
I have two tables. On is an inventory for all SKU in our store. The other is a request for product transfer from a supplier
So table one: SKU, qty in stock
Table two: SKU, requested qty, request status
Once the request is processed, I need one action that will:
Add the requested qty to whatever qty is already in stock in table 1
If the sku is not already in table 1: create it and add requested quantity.
Change the request status to “transfered”
How do I proceed to do this?
In general, you could explore the reference actions and add a row to another table action.
The referenced rows action will be “set the values of some columns in this row” with expression something like [Qty]= [Qty] +[Reuested Quantity]
You could try action type “add a new row to another table using the values from this row”
User | Count |
---|---|
41 | |
27 | |
27 | |
20 | |
13 |