Google Sheets call back issue

MIT App Inventor Help
#1

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.

Backupblock
Backupblock808×284 31.6 KB

Then after I get confirmation that the clearing operation has completed, I will save the rows:

Saveblock
Saveblock1492×792 110 KB

However, even though I can verify that the spreadsheet has been cleared, the "FinishedClearRange" function never gets called and the rows never get saved.

Anyone have any insight?
Thanks!
-Bryon

#2

Hello Byron

I think your code needs to first verify that the whole range exists before it is Cleared.

#3

Hi Chris!

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.

Thanks.
Bryon

#4

That's not the same as a range of cells though.....

#5

Technically, you're right. But I did have lots of data in the range and it cleared. Placing data in F200 is easy for testing.

Seems like a bug.

#6

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.

#8

If this is the AI2 component then @Susan_Lane should be contacting you.

#10

Can confirm the event does not appear to be firing, the method (clearing the range does work)

image

On pressing Button 2, the range is cleared on the spreadsheet, but the label is not written out with "Cleared Range".

1 Like
The new spreadsheet update on AI2 doesn't work for me
#11

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:

"Unable to parse range: Sheet0A1:F500"

sheet0
sheet0818×336 42.2 KB

error
error856×180 22.4 KB

#12

Yes this does appear to be an issue. I've logged it here and proposed a fairly straightforward solution on our end.

1 Like
FAQ Section: Google Sheets
#13

That was a good idea.

#14

Great! Thanks for looking into and logging this. Also, thanks to everyone else here as well for their ideas and testing!

-bryon

1 Like
#15

Thanks for this report and all the details.

#16

(added to Open Issues section of FAQ)

#17

We have merged a fix for this issue. It should go out with our next release.