Adding value to another sheet when creating a new entry in one table

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?

1 Like

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”