Unable to automatically update inventory

[MEC]

Hi,

I created an inventory app where I can add and sell products. My problem is, I have an in-app formula

[Initial stock]+SUM(SELECT(Add[Quantity],([Product] = [_THISROW].[Product Id])))-SUM(SELECT(Sales[Quantity],([Product] = [_THISROW].[Product Id])))

but the update on current stock only happens when I edit the product page.

Is there a way to auto update it without editing the product page?

[Koichi_Tsuji · Accepted solution]

I reckon you have your app formula inside the physical column, so it will not be updated unless the row is update physically to evaluate the formula.
Move the formula to virtual column so that the calculation always returns the update result.

[MEC]

That was fast @tsuji_koichi. Thank you. All good now.

[jhonnym62]

friend did it that way but it does not update as fast as I would like, what do you recommend?

[Agilland]

Is there any way to update current stock via google sheets to relfect Appsheets "Current Stock"?

[L_John]

Using your formula I was able to resolve an issue that I was facing. Thanks a lot.