Query having different results in "Preview" and in actual "Run"

Hello everyone,

I'm quite new to Retool, so please bear with me.

I've tried to update my database using an API request when someone clicks on a button in a table.

The setup looks like this:

The idea is that I use {{table1.recordUpdates[i].name}} to get the updated name of the current column I want to update. And it does display the value as you can see below:

Now, if I click on "Preview" it shows the API request exactly as I would expect:

But if I click on "Run" suddenly the "name" field is null:

Any help to why this is happening would be greatly appreciated!

Thank you and have a great day

1 Like

Hey @Padierfind! Happy to help with this. To double check, are you editing your table before running the query? As in, is there data inside recordUpdates?