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”

https://www.appsheet.com/samples/This-app-shows-how-to-use-reference-actions?appGuidString=e76d2e73-3d26-475c-a8f8-9911f5015920

2 Likes