Append to the wrong cells

[harryhow]

Any one has an issue that although I assigned D3 cell to be appended but it turns out A3 (and A4, A5...) to be written?
Don't know why, following image on the right side is my log from my NodeRed debug message.

1st time is D3 to be written (this is correct), following turn becomes A4, A5 to be written. (this is wrong)
Any leads on this issue?

[sammachin]

What is the structure of the data you are writing (msg.payload)

…

On Mon, 25 Oct 2021 at 18:30, Harry Chen ***@***.***> wrote: Any one has an issue that although I assigned D3 cell to be appended but it turns out A3 (and A4, A5...) to be written? Don't know why, following image on the right side is my log from my NodeRed debug message. 1st time is D3 to be written (this is correct), following turn becomes A4, A5 to be written. (this is wrong) Any leads on this issue? [image: image] <https://user-images.githubusercontent.com/693098/138742123-5ca4a738-a5ee-4511-868c-82e130488040.png> — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#16>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AABNZ7NW7WXKBKXECDGGOOLUIWH3JANCNFSM5GV2CL5Q> .

[harryhow]

It's a simple message coming from MQTT text input. Looks like this

New investigation: my google sheet is associated with a Google Form, once the sheet data on the Google Sheet has edited by the Google Form submission, the wrong cell appending behavior happened.

[santi19z]

Any one has an issue that although I assigned D3 cell to be appended but it turns out A3 (and A4, A5...) to be written? Don't know why, following image on the right side is my log from my NodeRed debug message.

1st time is D3 to be written (this is correct), following turn becomes A4, A5 to be written. (this is wrong) Any leads on this issue?

Any solution in this?? I have the same problem. I'm trying to write in two different columns but always send the date to the first column.

[sammachin]

@santi19z are you also updating your sheet via a google form? this issue relates to that which seems to be a bug in the interaction between the google api and forms?

Could you provide an example of the issue?

[santi19z]

I'm not a Node-Red expert, but I'm trying to save data from a PLC into two different columns on the same sgoogle spreadsheet directly .

When I run the flow I get this result in the google spreadsheet.

[sammachin]

ok so this isn't a google forms related issue.

What is that S7 Volumen node doing, and what is the configuration in the google sheets node, you're splitting the flow after the S7 node so copies of the message will be sent to both sheets node and that will execute each one.
Can you export an example flow so I can try to reproduce your issue

[santi19z]

ok so this isn't a google forms related issue.

What is that S7 Volumen node doing, and what is the configuration in the google sheets node, you're splitting the flow after the S7 node so copies of the message will be sent to both sheets node and that will execute each one. Can you export an example flow so I can try to reproduce your issue

The S7 Volumen node is just reading a number from a PLC. This variable is just for test, and with the timestamp node I was trying to inject the time and date in the column A of the Google Spreadsheet and the Volumen in the column B. But I get the wrong write in the file.

As an example I sending you the test of what I'm trying to do. You can ignore the S7 nodes.
test_flow.json

[sammachin]

ok,

You are using the Appen Row funciton in the sheets node, so this will add a whole new row starting at the cell you specify.

If you want to write to 2 cells in the same row you need to combine those values into an array eg ["val1", "val2"] before sending it to the sheets node

[lenoldvaz]

I'm getting a similar error, where the append row shifts cells after the first row is added.