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:
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.
this makes life better, but in case the variable PharmacyName is changed , it updates again the header instead of creating a new row