Google Sheets for AppInventor

(replication of the upcoming component for AI2, using blocks and a google apps script web app)

UPDATE

I have now written an extension to work with the google apps script, no more complicated blocks!

See HERE for more details

INTRO

Just for fun, I thought I would have a go at replicating the components created by Tommy Heng for the upcoming Google Sheets component in AppInventor. I have used a google apps script web app to handle all the functions and created a demo app to show most of the functionality. I have also added in a couple of things that were commented on in the topic on the forum. I will provide a "barebones" app project as well that simply handles the connection with the web app - just the back end of things, so developers can build their own thing. Perhaps the only main difference is that I have not handled situations where, in the proposed component, blocks are combined to get the A1 notation reference and then run another function with them. This can be done, but would need to be in an asynchronous way - do the first, then once done, do the second.

WEB APP SCRIPT

Notes:

BLOCKS

RESOURCES

HOWTO: Create a Google Apps Script Web App bound to a Spreadsheet

Link to Spreadsheet  (note: this is editable for people with a google account, and the data is reset every 24 hours - 3-4 am GMT)


Note: