I am trying to bulk update a google sheet based of displayed values in a table, but I'm getting a never ending query.
I have set up the query and I have triggered it via a button. I've made sure all primary keys match. I am able to get the data from the spreadsheet no problem, but whenever I try to update it the query just keeps running endlessly and nothing happens in the spreadsheet.
I have tried appending values as well and it doesn't work.
Here is the setup:
Here you can see the console log from the script:
One thing to note also is that the query run never appears under the "running" tab of queries in the console.