Hey @AnsonHwang! Thank you for such clear repro steps—I was able to repro the exact issue and will keep you updated on a fix. Are you blocked? If so, happy to try to rush the fix and also potentially find a workaround for you in the meantime!
Users need to set a primary key on their List Views — we don't know that the data changes unless there's a primary key set. They should also store their changed values in an external state so returning to the page restores the intended values.
Do you know if either of these would help your use case?
Yes, I have added a query to the change event of checkbox to persist it in the database. I did examine the data and make sure the data is correct save in database.
What version of Retool are you using? It looks like the fix shipped on 3.40, so you'd need to try edge 3.40 or higher or at least 3.52 if using stable releases.