Appsheet Inventory management item QTY doesnt change when i edit the created form

[KirigayaKazu]

Hey guys so im new in appsheet currently making a borrow system, i need help when i input a data then saved it the "Item" qty in the other column change but then after the item is returned i edited the saved form from return and change the value again to return the last value from the other form but it doesnt change rather when i create a new form and add the same qty item, ofcourse that would change the value but i want it to change from the last form rather than creating from a new one.

[WillowMobileSys]

You probably have an Initial Value expression and are expecting it to update the value again when a change is made on Edit?

Initial Value expressions will set and adjust the column value ONLY when it is a NEW row - unless you use "Reset on Edit" - see below.   

If your intention is to allow the user to edit the column value, then yes you need to the Initial Value expression so users can modify the value afterwards if needed.

If you do not need users to manually modify the column value and just want it to always be set by an expression when the row is edited,  then place the expression in the "App formula" property.  Note that this also prevents any actions from applying updates.

To have the expression also apply on row Edit, you will want to use the "Reset on Edit" property.   You can simply turn it on and the the Initial Value expression will always be re-triggered.  Or you can apply an expression to control WHEN the "Reset on Edit" executes.  For example, I many times what a column value to change on Edit only when a certain column was changed.  So I might place an expression in the "Reset on Edit" property like this:

[_THISROW_BEFORE].[Changed Column] <> [_THISROW_AFTER].[Changed Column]

This expression will re-trigger the Initial Value in THAT column only when [Changed Column] value has changed. 

I hope this helps!!