Hi, I am new to this platform. I am experimenting on Gsheets until Devops connects our main postgresDB.
Details: I am using a Gsheet to generate a table. I use a query to read data from my Gsheet.
Goal: I am trying to create another query to let the users edit one of the columns in my table.
I saw the changesetArray function in the docs. I am using it to update the changed cells in the second column. When i try to change a cell, it brings up the save/cancel menu. 1st save doesn't work and the second brings the error in the screenshot.
I use the primary key as described in the examples.
What am I doing wrong?