Has anyone experienced this and know how I can solve this problem?
So what exactly is the issue? The other toggles are moving when you change one? What code do you have for the id? Do you know that the id listed there is the id WeWeb assigns to the table? Not the id you see on the left, the uuid. What’s the formula to fetch the id?
I’m making some guesses about your setup, because your information is still very sparse, but hopefully I guessed right and this helps hah.
So in my experience, linking directly to those items (id, created_at) like that hasn’t been successful, because the order of a table within WeWeb changes, even on page refresh. So every time you refetch the collection, the information you’re connecting to can change and it’s saving the information to the wrong spot.
I prefer to do a more solid reference to the database table. You can do that with the lookup function. I’ve attached a screenshot of exactly what I do in my database update function in the ID formula to get exactly the row I want.
Use the lookup function to lookup the row within the table I want to reference by something easier to search for, the name in my case. Then that returns my uuid which I feed into the update function to do what I want. The same result could be achieved by just copy/pasting in the uuid from your database. I’m assuming you have this code on every toggle?
You also shouldn’t need to fetch the collection before running the update I don’t believe. Just afterwards to refresh the data once you’ve updated the database.
