I have a query that does an update row to a Google Sheet. However it is updating a column that isn’t in any of the fields I am feeding it. Is there a way to see exactly what is POST/PUT?
What is occurring is I am using an arrayformula to provide business logic to one of the columns, giving numbers for each row based on some logic. A particular row has “0” in that field. I run an update for that row and update other columns, then when I open that spreadsheet I find that the cell in the arrayformula column is now 0 instead of being blank and being filled in by the array.
So I want to inspect the query to make sure it is not providing a value for that column.
And then I need to figure out a way to make sure that column (and columns like it) are not updated.
(More detail in case anyone cares. My spreadsheet has two sheets. one sheet has a list of orders and a column that includes qty remaining. The other sheet is a list of shipments which includes which order and the qty shipped. The qty remaining column on the order sheet is an arrayformula which returns the header in row 1, blank in any blank rows, and quantity minus sum of related shipments from the shipment sheet. This is just one instance of business logic on the spreadsheet but there will likely be more in the future. I’m using a spreadsheet as my “database” because we don’t generate a lot of items and I am very familiar with scripting for spreadsheets.)
EDIT: it looks like the latter issue is the bigger one, finding a way to update a Google Sheets row without injecting values into an arrayformula column. Even though it reads “50” in that cell, Google Sheets doesn’t really have “50” there, it has an array at the top of the column which when expanded would display “50” in that cell.