Really could with some help if anyone knows the answer to this :)
On Form A I have the following bit of code in the "On edit > On Success" which updates Form B when Form A is edited:
- for each item in input.Products
- {
- inv = Product_Inventory [ID == item.Product_Name];
- inv.Available_stock = (inv.Available_stock + item.Quantity);
- }
However I have 2 fields that I need to be editable on Form A that do not update Form B when being edited.
Does anyone know how I can keep the above code in On Edit but it does not update if certain fields are edited?
I guess it needs an If statement in there but I don't know how to write it.
Please help! :)