I am a newbie in appsheet and I am facing a obstacle!!
So this is my form. I have to key in the details in left first, and press new, and it will lead you to the second image. Once at the second image, fill in the details again and press save, and it will save it in the form on the right. Then press submit, my inventory should change accordingly to the quantity I keyed in in the form on the right, but it is not changing!
This is my behaviors that i set. This is the rules that i set base on the photos respectively.
IF(
ANY(Stock In Out[Purpose]) = “Stock In”,
[Available Stock] + SUM([Related Stock In Out Parts][Quantity]),
[Available Stock] - SUM([Related Stock In Out Parts][Quantity])
)
SELECT(Inventory[Part Number], [Part Number] = [_THISROW].[Part Number])
I have also ensure that the behavior is linked to the form and the event is triggered when the form is submitted. But why is my inventory still not changing? Help!