I am trying to "delete" a row. Since there is no action available for this, I tried using "" while in formula mode in all the fields for the row I'm trying to update. It is giving me this error. However, I am using the Row ID from my search step, which does show that rows were retrieved.
Best Answer
P
Patricia Guevarra
said
about 7 years ago
Hi Saul,
Updating all the fields in the row with "" will cause this error. If you would like to clear all the fields, you should use "clear" instead, in formula mode without the quotes.
As for not having a prebuilt action for this, unfortunately, it seems this is also not supported via Google Sheets' API.
I hope this helps!
Answer
Patricia Guevarra
said
about 7 years ago
Hi Saul,
Updating all the fields in the row with "" will cause this error. If you would like to clear all the fields, you should use "clear" instead, in formula mode without the quotes.
As for not having a prebuilt action for this, unfortunately, it seems this is also not supported via Google Sheets' API.
Saul Macht
Google Sheets: 784 No such entry error
I am trying to "delete" a row. Since there is no action available for this, I tried using "" while in formula mode in all the fields for the row I'm trying to update. It is giving me this error. However, I am using the Row ID from my search step, which does show that rows were retrieved.
Hi Saul,
Updating all the fields in the row with "" will cause this error. If you would like to clear all the fields, you should use "clear" instead, in formula mode without the quotes.
As for not having a prebuilt action for this, unfortunately, it seems this is also not supported via Google Sheets' API.
I hope this helps!
Patricia Guevarra
Hi Saul,
Updating all the fields in the row with "" will cause this error. If you would like to clear all the fields, you should use "clear" instead, in formula mode without the quotes.
As for not having a prebuilt action for this, unfortunately, it seems this is also not supported via Google Sheets' API.
I hope this helps!