Any advise please.
I have a listview, when selecting an item, the app will read from a google sheet and the listview item and google sheet info will be plus or minus together and updated on the google sheet.
This works perfectly until I have more than one item on the listview.
Then calculation is totally wrong.
It is like a stock trade app, where you select stock from listview 1 (googlesheet) and that stock goes onto a user private listview (Listview 2).
Due to user selected a stock, that stock value went up to what it was when user selected.
now user wants to sell stock because shows profit, meaning I need to minus the value from listview 1 (googlesheet) with users listview stock.
This works perfectly if user only has 1 stock item (Gold) but as soon as it has 2 stock items (gold and silver) the calculation does not sum correctly.
Sometimes doubles the amount or minus incorrectly