I am doing a inventory app that calculate stock position as and when order are process. I have a view that presents a slice version of the inventory in table form.
I have been experiencing an issue that the table is not updated as I wish. For example, I have 10 pcs of stock of an item, I process an order for 4 [T1_Order], so after the order entry is completed. My main inventory should show 6 [T1_F]. However, that is not the case and it puzzled me that what might have gone wrong.
So I did a test to examine the data on the table through the Appsheet Editor immediately after the order is process to see whether it is due to some form of data transmission delay, that the Save function did not write the info fast enough.
The finding surprises me, the data fetch correctly reflect the data have been updated in the table.
However, I do not understand why the data in the slice view which tabulate the same data does not reflect the same?
Any help will be greatly appreciated.