Google Sheet Row Id changes every time

Hi
I’m using the current blocks to update some cells in a single row for each user in Google Sheets.


And for the row ID I’m using the current blocks to get the row ID.

The problem I’m facing is that the blocks sometimes work fine and update the desired row , but at other times it updates the wrong row like updating the header.

This is a problem:

The set app variable block is going to trigger before the new row is created in your data source. It needs to be in the “do” section so that it happens after the row is created.

1 Like

@tatiang
this makes life better, but in case the variable PharmacyName is changed , it updates again the header instead of creating a new row

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.