I'm saving a database to Gsheets and my workflow is to clear 200 rows and then save the data. With my current blocks I can do this separately but when I try to use FinishedClearRange, it doesn't fire:
To start off saving the database, I want to clear the old data first.
However, even though I can verify that the spreadsheet has been cleared, the "FinishedClearRange" function never gets called and the rows never get saved.
The code seems to be quite happy to clear the cells. I populated the cell at F200 and it clears just fine. Not sure what other functions or callbacks I need.
I know I could forego the callback completely and just use the clock to create a delay but that is not the right way to do it. Waiting for the "ack" is the best.. if it's working.
It does, but it is a very straightforward case, no more complicated than the testing would have been before release of the App Inventor enhancement.
The difference between the calls: Clear Range is a signal sent by the App. Finished Clear Range is a signal sent by the Google API. Make sure your Google User, Google API, Google Project, permits that outgoing message.
I changed the sheetName to Sheet0 (there is no "Sheet0") to force an error on Google's side and did receive a correct error response from Google's API confirming the connection permissions:
