I would like to create an app which would allow my students to submit their results to me. I was thinking that I could do this via MySQL, but if other teachers wanted to use my app, I don't want them to all have to be dependent on my MySQL server. So, I was thinking it would be nice if I could just submit the results through a Google Form that I create and that form would then store the results in a Google Spreadsheet. Nice idea, no?
This way, any student could submit their results and the results would automatically be stored in my database. Only problem is, I don't see a way to make this happen. There is a Google Forms API (https://developers.google.com/apps-script/reference/forms/) but I can't see how to access it from Corona (it would be nice if it was RESTful). I guess it would be possible to use showWebPopup() and then actually just pull up the Google Form web page? But that seems to lack finesse!
I know there is also a Google Spreadsheet API, but I have the same problem as with the Google Forms API- no way to run the scripts from Corona.
If anyone has thoughts on this, I would greatly appreciate it. Thanks!