Stock update

AppSheet AppSheet Q&A
,
1

Hi,

I have:

Ingredients (Ingredient | Stock)

Recipes (Product | Ingredient I Used Qty)

Products

Ordered Products ( Order | Product)

Orders ( Ordered Product | Qty)

Problem:

I need to update the Ingredient stock every time a product is added to an order or when an order is canceled.

Ideally with actions only and not automation.

I am thinking at looping with actions but can’t see through it on how I would achieve it.

Thanks!

2

Why don’t you simply create another virtual column in Ingredients which will calculate your stock less active order quantities?

1 Like